Thread
:
Display Empty Cell When Using SUM formula
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Display Empty Cell When Using SUM formula
Before Harlan jumps in and being more picky than even the OP, would it not
be better to use:
=IF(COUNT(.....)=0,"",SUM(.....))
I know that it is a Sales Order Template but I suppose that it is always
possible that if there was a cancelled order, the credit note is entered as
a negative.
--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"T. Valko" wrote in message
...
Is the Total cell one of the cells cleared in your macro?
If so, why clear (delete) the formula? Just write the formula like this:
=IF(SUM(.....)=0,"",SUM(.....))
And remove that cell reference from your macro.
Also, you can simplify the macro to:
Sub NewSalesOrder()
Range("B2,B4:B13,E14").ClearContents
End Sub
--
Biff
Microsoft Excel MVP
"Koomba" wrote in message
...
I am using a Custom Sales Order Template. I use a macro to clear contents
(from previous sales order). I use SUM formula in the TOTAL cell and
wonder
if I can have the TOTAL cell show as empty (but leave formula intact)
after
macro clears contents. I am being picky here, I know.
Here is Macro:
Sub NewSalesOrder()
'
' NewSalesOrder Macro
' Clears Sales Order for new data entry
'
' Keyboard Shortcut: Ctrl+b
'
Range("B2").Select
Selection.ClearContents
Range("B4:B13").Select
Selection.ClearContents
Range("E14").Select
Selection.ClearContents
End Sub
--
Thanks from Salt Spring
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann