Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |