#VALUE! with if great than or less than x then do this formula

[TeressaJP]

my formula below is returning #VALUE

What I need is: If C2 is "New" and G2 is less than 7 but greater than 3 then return .0.1; If G2 is less than 5 but greater than 3 then return .0125; If G2 is less than 3 but greater than 0 then return .015; if G2 equals zero then return zero.

If C2 is "Renewal" follows same as above but with different returns. What am I doing wrong?


'=IF(C2="New",IF(G2<7>3,0.01,IF(G2<5>3,0.0125,IF(G2<3>0,0.015,IF(G2=0,0.02,0))))),IF(C2="Renewal",IF(G2<4>3,0.01,IF(G2<3>0,0.015,IF(G2=0,0.02,0))),0)

 

[TeressaJP]

here's one way.
I haven't tested it, but it probably works

=if(g2>7,0.5,if(g2=0,0.2,if(g2<3,0.015,if(c2="new",
if(g2<5,0.0125,if(g2<7,0.01,0)),if(g2<4,0.01,0)))))

what do you want to do if g2=7 exactly ?
Maybe change >7 to >=7.
Or change <7 to <=7.

awesome! Thanks.