| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Basic If
I am trying to write the if function for the following
If the sum of A1:E1=0 then "-" if not then sum of A1:E1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Basic If
Here's the formula you asked for:
=IF(SUM(A1:E1)=0,"-",SUM(A1:E1)) But, try this first.... FormatCellsNumber Tab Category: Accounting Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Trying To Excel" wrote: I am trying to write the if function for the following If the sum of A1:E1=0 then "-" if not then sum of A1:E1 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Basic If
Another approach would be
=SUM(A1:E1) and custom format General;-General;"-" -- Regards, Peo Sjoblom (No private emails please) "Ron Coderre" wrote in message ... Here's the formula you asked for: =IF(SUM(A1:E1)=0,"-",SUM(A1:E1)) But, try this first.... FormatCellsNumber Tab Category: Accounting Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Trying To Excel" wrote: I am trying to write the if function for the following If the sum of A1:E1=0 then "-" if not then sum of A1:E1 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Basic If
Thanks Ron, It worked just fine
"Ron Coderre" wrote: Here's the formula you asked for: =IF(SUM(A1:E1)=0,"-",SUM(A1:E1)) But, try this first.... FormatCellsNumber Tab Category: Accounting Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Trying To Excel" wrote: I am trying to write the if function for the following If the sum of A1:E1=0 then "-" if not then sum of A1:E1 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Basic If
Thanks
"Peo Sjoblom" wrote: Another approach would be =SUM(A1:E1) and custom format General;-General;"-" -- Regards, Peo Sjoblom (No private emails please) "Ron Coderre" wrote in message ... Here's the formula you asked for: =IF(SUM(A1:E1)=0,"-",SUM(A1:E1)) But, try this first.... FormatCellsNumber Tab Category: Accounting Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Trying To Excel" wrote: I am trying to write the if function for the following If the sum of A1:E1=0 then "-" if not then sum of A1:E1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking to Visual Basic for Applications Help Files | Excel Discussion (Misc queries) | |||
| Visual Basic and SP2 | Excel Discussion (Misc queries) | |||
| Microsoft lessons should be listed from basic to advanced | New Users to Excel | |||
| Macro Calling Visual Basic References | Excel Discussion (Misc queries) | |||
| Visual Basic Code Remains in "memory" | Excel Worksheet Functions | |||
Linear Mode
