## Basic Formula Help (I think basic...)

### Basic Formula Help (I think basic...)

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

### Basic Formula Help (I think basic...)

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

http://www.yqcomputer.com/

### Basic Formula Help (I think basic...)

Thank you for the advice Peo. I'm not up to speed on the "vlookup"
function- but I do understand the second formula. I give it a go.
Appreciate you taking the time to lend a hand!

--
michaeld13
------------------------------------------------------------------------
michaeld13's Profile: http://www.yqcomputer.com/

### Basic Formula Help (I think basic...)

Actually, I figured out Vlookup and that's working great. Thanks agai
for the help ;

### Basic Formula Help (I think basic...)

Debra Dalgleish has nice instructions at:
http://www.yqcomputer.com/

--

Dave Peterson
XXXX@XXXXX.COM