If statement based on multiple cells

[chally3]

Hi all,

This is probable a really easy one for someone but I have complete brain fog

I have the straight forward formulae =IF(ISBLANK(N2),"PO not raised","PO raised") below but wish to add the following and just cannot w9ork it out

I wish the formula to also look at column T and if that has a "X" override the formula above and return 'marked for deletion' ( an item can be marked for deletion if it has,or has not a PO raised.

Thank you

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=if(T2="X","marked for deletion",IF(N2="","PO not raised","PO raised"))

 

[Kaper]

Try:

=IF(T2="X","marked for deletion",IF(ISBLANK(N2),"PO not raised","PO raised"))

 

[chally3]

Thank you, profile updated

 

[Fluff]

Thanks for that.