IF Function to run a formula if value is false
Posted by CHRIS on February 21, 2001 1:12 PM
How do you get an IF function to run a formula if adjacent cells contain data? The function should do nothing the adjacent cells dont contain data.
Posted by Aladin Akyurek on February 21, 2001 1:22 PM
A simple example would be:
=IF(A1<>"", SomeFormula,"")
When A1 is non-empty, SomeFormula will run, otherwise the cell in which this IF-formula is entered is 'blank".
Perhaps, you have something different in mind. If so, care to elaborate with an example?
Aladin
Posted by Mark W. on February 21, 2001 2:25 PM
I'd recommend the use of the ISBLANK() function
instead of testing for a text string of 0 length.
Try using:
=IF(ISBLANK(A1),"",<your formula here>)
