Notifications
Clear all
General Excel Questions & Answers
3
Posts
3
Users
0
Reactions
91
Views
Topic starter
I need one cell to mimic another cell.
If H2=Y or N, I need I2 to copy that it is Y or N as well.
I was able to get =IF(H2="Y","Y","") which worked but I can't seem to add on the second part which is for the "N" part.
Thanks
Posted : 17/11/2018 5:07 pm
Hi Brittany,
In I2 you just need
=H2
Regards
Phil
Posted : 17/11/2018 6:40 pm
Hi Brittany,
If H2 only has Y or N as parameters then you just need to do as Phil suggests. But if H2 is to have more inputs than just those two you need to write a formula to catch the content when there is a Y or N. There are different methods you can use, I am showing you one way to write such formula.
=IF(OR(H2="Y",H2="N"),H2,"")
Br,
Anders
Posted : 18/11/2018 3:46 am