Help with simple formula... PRETTY PLEASE :)?

[kittykatkat]

Hi, I am a new excel user and can't figure out my IF formula.

I'm trying to use this in an invoice for a vacation rental company.. I don't know what I am doing wrong...

=IF(A1="HIGH",95,0)+IF(A1="APRIL",110,0)+IF(A1="LOW",80,0)

I want it to do $95 for when the cell says HIGH, for high season ... and $110 when cell says "APRIL" and $80 for "LOW" season.

Thank you!!!!

 

[Smitty]

Welcome to the Board!

If you're going to have more conditions then a lookup table would be more flexible, but this should work:

=IF(A1="HIGH",95,IF(A1="APRIL",110,IF(A1="LOW",80,0)))

HTH

 

[Jonmo1]

Welcome to the board.

Try
=IF(A1="HIGH",95,IF(A1="APRIL",110,IF(A1="LOW",80,0)))

 

[Repush]

This formula works OK here, does A1 have the right input?

Best regards, Henk