IF function with TRUE and FALSE equations

[jdohlinger]

I am trying to use a simple IF function but I would like the answer if true to be the value of an equation pulled from that rows cells. Is this possible?

I wrote the equation...

=IF($E2>=$I2,"=($G2*$H2)","false")

However IF true, "($G@*$H2)" appears in my cell and not the value of that equation. Is there a better technique to preform this function?

[oeldere]

Try this one

Please Login or Register  to view this content.

[Ace_XL]

oeldere's formula will give you the results.

But you could do away with the "false" unless you want it displayed in lower case . The IF function will default to FALSE if the condition is not met

Hence, simply use
=IF($E2>=$I2,$G2*$H2)