NESTED "IF" and "AND" functions

[caitlin87]

I am trying to write a formula that will satisfy the following:

C1 and G1 are number values.

IF (cell E1 does not contain any text) AND (G1-C1-12.5>=0), then output (G1-C1-12.5), otherwise output nothing (""). BUT, IF (cell E1 DOES contain text) AND (G1-C1-13>=0), then output (G1-C1-13), otherwise output nothing.

Can anyone help??

[Special-K]

Try

=IF(AND(E1="",G1-C1-12.5>=0),G1-C1-12.5,IF(G1-C1-13>=0,G1-C1-13,""))

[caitlin87]

That worked beautifully! Thank you!