Forum Discussion
IF function query
I am trying to enter a formula which I think should be an IF function. I can get it to work with just one logical test value but need to add 2 others. If text entered in E column cell = UFN or CP o...
Hi Wendy,
In this case, you have an option to embed the OR function inside the IF function as follows:
=IF(OR(E1="UFN",E1="CP",E1="IP"),"n/a","")
I hope this helps you
Regards
Thanks Haytham, I thought there needed to be an OR in the formula but wasn't sure where to put it. I will try this. Thanks again.