if zero

N

nowfal

hi,

In my work sheet i have uncheck tool>option>view>zero values,
now in one cell i need the zero value should show either as zero o
NIL. If i am giving IF formula it works when it is zero, but when th
real balance comes the cell shows as blank.
the formula is as follows
=IF(H9-H10=0,"nil","")
i think after that 'nil' some correction is required,

thanks
by
nowfa
 
M

Michael Malinsky

=IF(H9-H10=0,"nil",H9-H10)

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh
 
E

ElsiePOA

If I understand you correctly, you don't want zero values to appear i
cells generally, but in this one specific case you do.

If that is correct, the fromula that you have entered into (I assume
cell H11 should be changed to read =IF(H9-H10=0,"nil",H9-H10). Tha
will give you a "nil" when the value is zero and the actual result i
it is other than zero. If you prefer a zero to the "nil", replac
"nil" in the formula with "0"
 
P

Paul B

nowfal, see if this is what you want
=IF(H9-H10=0,"nil",H9-H10)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
N

nowfal

THANK U VERY MUCH, ALL OF YOU 3, I GOT THE REPLY WITHIN MINUTES, THAT
GREAT
BY
NOWFA
 
Top