MrExcel Publishing
Your One Stop for Excel Tips & Solutions

IF function - a null false value ?


Posted by Katherine Hickey on January 19, 2001 11:15 AM

Can anyone tell me how to update a cell only where a formula evaluates to true. ie. if it evaluates to false, leave the value as it is.
=IF(A1=A2,A3,???)
Thanks.


Posted by Mark W. on January 19, 2001 11:36 AM

Leave what value as it is? The value where the IF()
function resides

Posted by Steve Riedmueller on January 19, 2001 2:39 PM

She might mean:

If(A1=A3, A4, "")

That would be a "null false value" I suppose.

Posted by Mo on January 19, 2001 3:59 PM

Hello there, If I understand you correctly, then it should be fairly simple to solve.
Suppose A1=23. Assume if true then its "good", if false then leave as 23.
=IF(A1=23,"good",A1)
Hope it works


Posted by Katherine Hickey on January 20, 2001 1:30 AM

Thanks for the suggestion, unfortunately it generates a 'circlic reference' (the formula in A1 refers back to itself), as do all the workarounds I have tried. The suggestion from Steve Riedmueller (the false value = "") will clear the cell...to hopefully clarify my problem, thuis is what I want to do...
=IF(CellX=CellY,set a new value,leave the previous value as it is)
...thanks for any suggestions.