IF formulas?

[Oliv3oyl]

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

 

[Luke M]

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*200,IF(AND(G1>=20,G1<=35),G1*600,"Did not match criteria")))

 

[Teethless mama]

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

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

 

[Mike H]

Maybe

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

Mike

 

[Bob Phillips]

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

 

[Oliv3oyl]

Thank you! This is what I was looking for.

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*200,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]

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

 

[ShaneDevenshire]

Hi,

you can do this with VLOOKUP also, set up a lookup range like this in C14
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.