Can IF function result in its answer in a different cell?

[donaldberends]

Can this Formula work? Where if c2<e5 then its value is a number.
The formula below is what i tried but it didnt work

=IF((C2<E5);"c5=value=f5")

[daddylonglegs]

A formula can only put a result in the cell in which it resides. If you want C5 to be the same as F5 if C2 < E5 then put this formula in C5:

IF(C2<E5;F5;"")

[Richard Buttrey]

Hi,

Try

Please Login or Register  to view this content.

where the result is the F5 value if C2 is less than E5, otherwise blank

HTH