using a function based on the value of a function

J

Judy

Can anyone provide instruction on how to make a secondary function (in a
separate column) look up the value (result) of the first function without
having to paste the values. Thanks in advance!
 
Z

zackb

Hi Judy,

Not sure if I follow. But maybe you can use an IF function ...

=IF(A1=4,"A1 equals 4","")

This says that if the value (formula result) of A1 equals a numeric value of
4, then have this formula return the text "A1 equals 4"; and if it doesn't,
then return a null string ( "" ). Does this help?
 
Top