2 text IF arguments

[CVN55]

Hi
How do I create to IF arguments for the same cell relating to text:

So if cell A1 = "Non Portfolio" or "Portfolio status not yet known" then I want it to output "ALL COSTS", if false, then just blank.
So normally for 1 argument it would be =IF($C$33="Non Portfolio"," ","ALL COSTS")

Thank you,
Catherine

 

[louisH]

Hi,

=IF(OR($C$33="Non Portfolio", $C$33 ="Portfolio status not yet known"), " ", "ALL COSTS")

Something doesn't add up in your post. You said cell "A1" so why are you using cell C33 ?

Shouldn't your formula be :

=IF(OR($A$1="Non Portfolio", $A$1 ="Portfolio status not yet known"), "", "ALL COSTS")

Also if you want to display "ALL COSTS" if the condition is TRUE, you need to put it in the IF TRUE parameter of the If function, like this :

=IF(OR($A$1="Non Portfolio", $A$1 ="Portfolio status not yet known"), "ALL COSTS", "")

 

[CVN55]

Sorry the A1/C33 was my error! This works perfectly, thank you and it was the latter that I wanted to do!

Thank you so much!