Forum

Notifications
Clear all

If Formula question

3 Posts
3 Users
0 Reactions
91 Views
(@bpcowans)
Posts: 1
New Member
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
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
 

Hi Brittany,

In I2 you just need

    =H2

Regards

Phil

 
Posted : 17/11/2018 6:40 pm
Anders Sehlstedt
(@sehlsan)
Posts: 972
Prominent Member
 

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
Share: