Is there a way to add to this to say if it = 0 then 0 else blank ?
=IF(SUM(D19:D25)=0,"0",SUM(D19:D25))
Thanks for your help in advance last peice of this excel sheet I wont have to touch again =)
Is there a way to add to this to say if it = 0 then 0 else blank ?
=IF(SUM(D19:D25)=0,"0",SUM(D19:D25))
Thanks for your help in advance last peice of this excel sheet I wont have to touch again =)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks