Ignoring blanks

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

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

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" <exsam21.21uaxy_1137603601.2093@excelforum-nospam.com> wrote in
message news:exsam21.21uaxy_1137603601.2093@excelforum-nospam.com...
>
> 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
>