Totally New to excel i need help please.
with this i have attached a screen shot.
how do i make the Zeros not to show when there are nothing in the other column.
Thank you
Totally New to excel i need help please.
with this i have attached a screen shot.
how do i make the Zeros not to show when there are nothing in the other column.
Thank you
Last edited by hyewiz; 11-13-2008 at 08:42 PM.
So you've got a formula like
=A1*1.1288
change to
=IF(A1="","",A1*1.1288)
It depends on your formula!, if that formula is in colmun C and it takes in to account column A you can write it like this:
=IF(A2="","",A1+C1) so it says; IF A2, is empty, then show empty, else show the sum of A1+C1.
Not all forums are the same - seek and you shall find
Ooops, sorry DD hows your toes?
Thank you for the fast reply
this is what i have now
D6 has this =B6+(B6*TAX)
and
D25 has this =SUM(D6:D24)
B25 has this =SUM(B6:B23)
what i want is D19, D20, D21, D22 and D23 not to show $0.00
when B19, B20, B21, B22 and 23 are empty.
Like i said i am total newbie please spare with me.
thank you
I think i managed to find correct me if i am wrong
D6 will have thisPlease Login or Register to view this content.
Thank you greatly appreciated, your help.
Last edited by hyewiz; 11-09-2008 at 02:10 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks