a Excel question
 

very often I need write a formula like "=if(a10, 1, "")", but the
second value "" really should just be leave the cell blank (doing
nothing). is there anyway of doing that in stead of "".

a Excel question
 

That IS leaving the cell blank, though not empty because there is a formula
in it.

wrote in message
ups.com...
very often I need write a formula like "=if(a10, 1, "")", but the
second value "" really should just be leave the cell blank (doing
nothing). is there anyway of doing that in stead of "".

a Excel question
 

Permit me to make a guess.

Most questions of this type revolve around the desire to return a value that
a graph will "by-pass", and not cause it to dip to the *zero* line.

If that be the case, try something like this:

=If(A10,1,#N/A)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


wrote in message
ups.com...
very often I need write a formula like "=if(a10, 1, "")", but the
second value "" really should just be leave the cell blank (doing
nothing). is there anyway of doing that in stead of "".