kittykatkat
New Member
- Joined
- Sep 23, 2015
- Messages
- 1
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!!!!
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!!!!
