IF formulas?
 

I need an excel formula that if cell G1 IS 0-6 THE H1 CELL = 0
IF G1 = 10-19 THE H1 IS G1 MULTIPLIED BY 200
IF G1 = 20-35 THE H1 IS G1 MULTIPIED BY 600

IF formulas?
 

What did you want to happen if G1 does not match any of those criteria?

=IF(AND(G1=0,G1<=6),0,IF(AND(G1=10,G1<=19),G1*20 0,IF(AND(G1=20,G1<=35),G1*600,"Did not match criteria")))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Oliv3oyl" wrote:

I need an excel formula that if cell G1 IS 0-6 THE H1 CELL = 0
IF G1 = 10-19 THE H1 IS G1 MULTIPLIED BY 200
IF G1 = 20-35 THE H1 IS G1 MULTIPIED BY 600

IF formulas?
 

=LOOKUP(G1,{0,10,20},{0,200,600})*G1

What is the value for H? if G1=7, 8, 9 or over 35


"Oliv3oyl" wrote:

I need an excel formula that if cell G1 IS 0-6 THE H1 CELL = 0
IF G1 = 10-19 THE H1 IS G1 MULTIPLIED BY 200
IF G1 = 20-35 THE H1 IS G1 MULTIPIED BY 600

IF formulas?
 

Maybe

=IF(AND(G1=0,G1<=6),0,IF(AND(G1=10,G1<=19),G1*20 0,IF(AND(G1=20,G1<=35),G1*600,"")))

Mike

"Oliv3oyl" wrote:

I need an excel formula that if cell G1 IS 0-6 THE H1 CELL = 0
IF G1 = 10-19 THE H1 IS G1 MULTIPLIED BY 200
IF G1 = 20-35 THE H1 IS G1 MULTIPIED BY 600

IF formulas?
 

=IF(G1<0,"",IF(G1<7,0,IF(G1<20,G1*200,IF(G1<36,G1* 600,""))))

--
__________________________________
HTH

Bob

"Oliv3oyl" wrote in message
...
I need an excel formula that if cell G1 IS 0-6 THE H1 CELL = 0
IF G1 = 10-19 THE H1 IS G1 MULTIPLIED BY 200
IF G1 = 20-35 THE H1 IS G1 MULTIPIED BY 600

IF formulas?
 

Thank you! This is what I was looking for.

"Luke M" wrote:

What did you want to happen if G1 does not match any of those criteria?

=IF(AND(G1=0,G1<=6),0,IF(AND(G1=10,G1<=19),G1*20 0,IF(AND(G1=20,G1<=35),G1*600,"Did not match criteria")))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Oliv3oyl" wrote:

I need an excel formula that if cell G1 IS 0-6 THE H1 CELL = 0
IF G1 = 10-19 THE H1 IS G1 MULTIPLIED BY 200
IF G1 = 20-35 THE H1 IS G1 MULTIPIED BY 600

IF formulas?
 

Thank you! I never thought to use the LOOKUP formula. That works as well.

"Teethless mama" wrote:

=LOOKUP(G1,{0,10,20},{0,200,600})*G1

What is the value for H? if G1=7, 8, 9 or over 35


"Oliv3oyl" wrote:

I need an excel formula that if cell G1 IS 0-6 THE H1 CELL = 0
IF G1 = 10-19 THE H1 IS G1 MULTIPLIED BY 200
IF G1 = 20-35 THE H1 IS G1 MULTIPIED BY 600

IF formulas?
 

Hi,

you can do this with VLOOKUP also, set up a lookup range like this in C1:D4
0
10 200
20 600
36

User the formula
=VLOOKUP(G1,C$1:H$4,2)
Or dispense with the table and use
=VLOOKUP(G12,{0,0;10,200;20,600;36,0},2)

Both of these ignore the fact that you didn't give us something for 7-9 or
greater than 36.

--
Thanks,
Shane Devenshire


"Oliv3oyl" wrote:

I need an excel formula that if cell G1 IS 0-6 THE H1 CELL = 0
IF G1 = 10-19 THE H1 IS G1 MULTIPLIED BY 200
IF G1 = 20-35 THE H1 IS G1 MULTIPIED BY 600