if function question circular reference [closed]
How can I specify the current cell value for a condition that evaluates to false? For example, function looks as follows
=IF(F1="null",I1, J1 )
The function exists in J1, so if F1 is null, then use the value from I1, otherwise leave J1 as is. Currently Err:522 appears in J1, since the function refers to itself.