Basic Formula Help (I think basic...)

[michaeld13]

Hello all. It's been a while since I've used any
"uncommon" (to me) funtions in Excel. What I'm trying to is th
following:
If cell A (it's a number) is between B and C (B and C represent a rang
of numbers) then Multiply A by D (another number).

So, if Cell A is between 1 and 5, then multiply cell A by 10. If it'
between 6 and 15, then multiply Cell A by 50, etc.

Thanks for any insight!!

Michael D.
www.SpeedGraphics.ne

 

[Peo Sjoblom]

You could use IF(AND if there are only a few values otherwise I'd suggest
something like this

=A1*VLOOKUP(A1,{0,0;1,10;6,50;16,100},2)

using if/and

=IF(AND(A1>=1,A1<=5),A1*10,IF(AND(A1>5,A1<=15),A1*50,"and so on"))

as you can see it is wastteful to use IF(AND
the above only cover your example but the first formula also cover an
imaginary >15 multiply A1 with 100


Regards,

Peo Sjoblom