Nested if statement again...

[kisboros]

If Q1=-.59, or -2.07, or -3.54, put $5.36, otherwise $4.88

Thank you!

[Dennis7849]

This is not a "nested" if function.

=If(OR(Q1 = -0.59,Q1 = -2.07,Q1 = -3.54),5.36,4.88)

format the cell with the currency option.

[kisboros]

Thank you very much;it's working fine.