Hi evryone!
im subtracting to a cell w/c is empty and iwant the output
to display zero.sample: (a1=10, a2=empty)if applied formula is "=a1-a2" normally it comes out
with a difference of 10..
hepl will be very much appreciated
thanx n advance..
Hi evryone!
im subtracting to a cell w/c is empty and iwant the output
to display zero.sample: (a1=10, a2=empty)if applied formula is "=a1-a2" normally it comes out
with a difference of 10..
hepl will be very much appreciated
thanx n advance..
Prehaps
=IF(A2="",0,A1-A2)
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
thanx alot mate!
another one,on normal view evrything in my sheet seem ol
gud specially d alignment of headers and stuff but when
i try to print preview its ol messed up. does anyone hv
an idea what went wrong?? im sorry if this sound so
lame but i dont reli have any idea.
Last edited by oldchippy; 05-27-2007 at 10:18 AM.
May be your spreadsheet is too large to fit in one page by default.
Try File-Page Setup-Page and click on "Fit to 1 page wide and 1 page tall"
Then print preview. You will get a smaller text size but everything will be on 1 page only.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks