Thread: How would I eliminate the $0.00/column & keep formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default How would I eliminate the $0.00/column & keep formula
hi
not sure what your formula is but try something like this.....
=if(yourformula = 0, "", yourformula)

regards
FSt1

"Ro1" wrote:

I am trying to set up an invoice, but I don't want the $0.00 in the column.
Reply With QuoteReply With Quote