Help with nested if function

[MannyLNJ]

I need to write an if function that will do the following

IFC1 is greater than G1* . 90 set H1 to G1 * .90
IFC1 is greater than G1* . 84 set H1 to G1 * .84
IFC1 is greater than G1* .49 set H1 to G1 * .49
IFC1 is greater than G1* . 25 set H1 to G1 * .25
otherwise set G1 to ""

How to do I turn this into an IF statement

 

[MannyLNJ]

Thank you. Now that error is gone. The results don't make sense but the error is gone.

C22=1285.61
E22=71.63
G22=-999

so I expect H22 to be 1213.98 but it's showing -899.10

Any ideas?

 

[p45cal]

This is because the first If it encounters is True:
=IF(C22>G22*0.9,G22*0.9,
IF(C22>G22*0.84,G22*0.84,
IF(C22>G22*0.49,G22*0.49,
IF(C22>G22*0.25,G22*0.25,
if(G22=-999,C22-E22,""
)))))

if(1285.61>-999*0.9,-999*0.9,
becomes:
if(1285.61>-899.1,-899.1,

so I'm only guessing that you might want to check for -999 first?:

=IF(G22=-999,C22-E22,
IF(C22>G22*0.9,G22*0.9,
IF(C22>G22*0.84,G22*0.84,
IF(C22>G22*0.49,G22*0.49,
IF(C22>G22*0.25,G22*0.25,""
)))))

which with extra carriage returns removed becomes:

=IF(G22=-999,C22-E22,IF(C22>G22*0.9,G22*0.9,IF(C22>G22*0.84,G22*0.84,IF(C22>G22*0.49,G22*0.49,IF(C22>G22*0.25,G22*0.25,"")))))

I don't know...

 

[MannyLNJ]

Thank you again. Now it's working like I wanted it to.