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
|