Hi all,
Where i have the same text in two cells i want to display a text in the cell holding the formula.
Can anyone tell me what I need to do with this formula to get the correct result as i am trying different things but im not getting anywhere fast..
=IF(H2="BAD"+I2="BAD","BAD","-")
Thanks
legepe
Where i have the same text in two cells i want to display a text in the cell holding the formula.
Can anyone tell me what I need to do with this formula to get the correct result as i am trying different things but im not getting anywhere fast..
=IF(H2="BAD"+I2="BAD","BAD","-")
Thanks
legepe