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
|