Functions--I don't know what else to call them

  • Thread starter Thread starter Lyndsey
  • Start date Start date
L

Lyndsey

Ok here's what I want to do, but don't know how to
translate it to a fomula. I have 3 variables. I have a
total cost and I want to multiply that by different
variables depending on the total, for a retail price.

if total is less than 24 multiple by 20
if total is greater than or = 25 multiply by 15
if total is greater than 30 multiply by 12

Can someone help...PLEASE!!!

Thanks for any help
Lyndsey
 
Hi
if your total is in cell A1 try the following formula:
=IF(A1>30,A1*12,IF(A1>=25,A1*15,A1*20))

I assumed that all values below 25 (and not 24 as stated in your
description) are to be multiplied with 20
 
Thank you sooooo much. It was really quite logical and
simple, I just couldn't figure it out. Thanks again!
Lyndsey
 
One way:

You're criteria leave a hole, i.e., what if the total = 24? I assume
that the real critierion is if total is less than 25, muliply by 20:

=A1*(12+3*(A1<=30)+5*(A1<25))
 
Back
Top