Basic Formula Help (I think basic...)

Basic Formula Help (I think basic...)

Post by michaeld1 » Sat, 23 Oct 2004 04:31:38



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...)

Post by Peo Sjoblo » Sat, 23 Oct 2004 05:17:13

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...)

Post by michaeld1 » Sun, 24 Oct 2004 02:55:01


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/
View this thread: http://www.yqcomputer.com/
 
 
 

Basic Formula Help (I think basic...)

Post by michaeld1 » Sun, 24 Oct 2004 03:44:32


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

Basic Formula Help (I think basic...)

Post by Dave Peter » Sun, 24 Oct 2004 08:47:35

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





--

Dave Peterson
XXXX@XXXXX.COM