Ignoring blanks
 

How do I instruct a formula to ignore blanks? If a cell is blank, then
ignore, if not, execute the formula. Thanks.


--
exsam21
------------------------------------------------------------------------
exsam21's Profile: http://www.excelforum.com/member.php...o&userid=22666
View this thread: http://www.excelforum.com/showthread...hreadid=502526

Ignoring blanks
 

=if(a1="","",[your formula])


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=502526

Ignoring blanks
 

You cannot ignore it per se. You can get the formula to take a certain
action if it is blank, such as put "" in the cell, but it won't leave
whatever was in the cell before you added the formula.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"exsam21" wrote in
message ...

How do I instruct a formula to ignore blanks? If a cell is blank, then
ignore, if not, execute the formula. Thanks.


--
exsam21
------------------------------------------------------------------------
exsam21's Profile:
http://www.excelforum.com/member.php...o&userid=22666
View this thread: http://www.excelforum.com/showthread...hreadid=502526