In need of help...

[ksagert]

Hi There, I'm back again and I need another formula.

What I am trying to do is, I want cell A1 to say 'SAVE' if cell B1 is greater than 0, I want cell A1 to say 'CLEARANCE' if cell C1 is greater than 0, and I want cell A1 to say 'Regular Price' if cell D1 is greater than 0.

I tried to use the IF and AND expressions, but I was not able to get it working right. Can anyone help me out here?

 

[Jonmo1]

We need an order of precedense.

If any 2 or 3 are > 0, which do you want?

Can we assume if D1 is >0, you want "Regular price" regardless if B1 and/or C1 are also >0 ?

Or will only 1 of the 3 be greater than 0?