MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?


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>)