How can I replace zeros with blank spaces during calculations
I AM TRYING TO KEEP A RUNNING TOTAL ON A FORM. tHE PROBLEM I AM HAVING IS
THAT WHEN I EXTEND THE FORMULA TO A ROW, IT CONTINUES THE TOTAL ALL THE WAY
DOWN THE COLUM EVEN IF THERE IS NO VALUS IN THE SPOT BEFORE IT. I CAN SEND
OVER THE FORM IF IT WILL HELP EXPLAIN. THE CURRNT FOMLA IS SUM(I4+H5) BUT IF
H5 IS "0" THEN I DO NOT WANT IT TO TOTAL???
"Ted" wrote:
Ok, does anyone know how I can now add these two together, so I can run it
all in one cell please? I have added the to plug the zero problem, but are
unsure how I would add these two:
=IF(E30.5,E3,"")
=ROUND(7/(C3-D3),5)
Any suggestions please?
Ted
"Biff" wrote:
Hi!
Try this:
=IF(Z80.5,Z8,"")
That will leave the cell "blank". Not to be confused with EMPTY.
Biff
"Ted" wrote in message
...
I am trying to get excel to sum totals, but exclude answers that are
outside
of a certain range. I can get it to do this by using =IF(Z80.5,Z8,0).
However, I need it to display absolutely nothing in the cells, rather than
a
zero because it alters future calculations. Has anyone any ideas please??
Ted
|