| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if =0 ""
in K7 I have the sum of b7:F7
if sum b7:f7 = 0.00 then i want to leave k7 blank; but if there is data in b7:f7 I want the total my formula is =if(b7:f7=0,"",sum(b7:f7)) With figures in this range the current response is #VALUE I know it must be simple and I thought I had followed the logical tests etc that appear to prompt you but..... appreciate your clarification Bill |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if =0 ""
Hi bill,
Just try this. K7=IF(OR(B70,C70,D70,E70,F70),SUM(B7:F7)," "). The formula worked for me. Regards Ramana |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
if =0 ""
One way:
=IF(SUM(B7:F7)=0,"",SUM(B7:F7)) In article , "billy_bags" wrote: in K7 I have the sum of b7:F7 if sum b7:f7 = 0.00 then i want to leave k7 blank; but if there is data in b7:f7 I want the total my formula is =if(b7:f7=0,"",sum(b7:f7)) With figures in this range the current response is #VALUE I know it must be simple and I thought I had followed the logical tests etc that appear to prompt you but..... appreciate your clarification Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Functional difference b/n "" & " " | Excel Discussion (Misc queries) | |||
| Time Entries: Want to Skip the ":" | Excel Discussion (Misc queries) | |||
| Sumproduct to ignore text and "" | Excel Worksheet Functions | |||
| Graphing "" values | Charts and Charting in Excel | |||
| Place a "" around ALL values in a cell | Excel Worksheet Functions | |||
Linear Mode
