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

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/

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/

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/

Actually, I figured out Vlookup and that's working great. Thanks agai

for the help ;

Debra Dalgleish has nice instructions at:

http://www.yqcomputer.com/

--

Dave Peterson

XXXX@XXXXX.COM

http://www.yqcomputer.com/

--

Dave Peterson

XXXX@XXXXX.COM

1. Visual Basic 2005 vs. Visual Basic .NET (2003) and Visual Basic 6.0

2. BASIC Strings; Was: More SWI / BASIC SYS Help!

3. please I need help with basic ado.net save, basic syntax neede

4. please I need help with basic ado.net save, basic syntax needed

5. ASP.NET basic help i think.

6. basic asm help please problem with equ command i think

7. HELP ME, basic actionscript (I Think?)

8. looking for help (I think its a basic MATLAB question)

9. Need Visual Basic help, I think

10. Please help with basic (I think) subreports problem....

12. Redemption help needed (basic I think)

13. basic asm help please problem with equ command i think

14. basic problem..I think! Please help

15. My I's are coming up i's. (lower case)

5 post • Page:**1** of **1**