a Excel question

[yuzengw]

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

 

[PCLIVE]

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

 

[RagDyeR]

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(A1>0,1,#N/A)
--

HTH,

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


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