Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide $0.00
I am using Excel 2007.
I am using the following formula to calculate the total cost based on 2 cells: The formula is in Cell "F3" and is entered as this =B3*C3 How can I keep it from displaying $0.00 when the fields are empty? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide $0.00
Try one of these:
=IF(COUNT(B3,C3)<2,"",B3*C3) =IF(OR(B3="",C3=""),"",B3*C3) -- Biff Microsoft Excel MVP "J" wrote in message ... I am using Excel 2007. I am using the following formula to calculate the total cost based on 2 cells: The formula is in Cell "F3" and is entered as this =B3*C3 How can I keep it from displaying $0.00 when the fields are empty? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide $0.00
I tried the first one and it works perfect.
Thanks. "T. Valko" wrote: Try one of these: =IF(COUNT(B3,C3)<2,"",B3*C3) =IF(OR(B3="",C3=""),"",B3*C3) -- Biff Microsoft Excel MVP "J" wrote in message ... I am using Excel 2007. I am using the following formula to calculate the total cost based on 2 cells: The formula is in Cell "F3" and is entered as this =B3*C3 How can I keep it from displaying $0.00 when the fields are empty? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide $0.00
Hi J,
An alternate solution which might be considered is to suppress the display of zero on the sheet. In that case you hide all 0's from view or printing but they still remain in the cell. This effects the entire sheet on which you apply it. Choose File (Office Button), Excel Options, Advanced, Display options for this worksheet, and uncheck "Show zero in cells that have zero value." -- Cheers, Shane Devenshire "J" wrote: I am using Excel 2007. I am using the following formula to calculate the total cost based on 2 cells: The formula is in Cell "F3" and is entered as this =B3*C3 How can I keep it from displaying $0.00 when the fields are empty? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide $0.00
Or just a custom format like
$#,##0.00;-$#,##0.00; That way the OP can suppress the display of zeros where he/she wants it only and not in the whole workbook -- Regards, Peo Sjoblom "ShaneDevenshire" wrote in message ... Hi J, An alternate solution which might be considered is to suppress the display of zero on the sheet. In that case you hide all 0's from view or printing but they still remain in the cell. This effects the entire sheet on which you apply it. Choose File (Office Button), Excel Options, Advanced, Display options for this worksheet, and uncheck "Show zero in cells that have zero value." -- Cheers, Shane Devenshire "J" wrote: I am using Excel 2007. I am using the following formula to calculate the total cost based on 2 cells: The formula is in Cell "F3" and is entered as this =B3*C3 How can I keep it from displaying $0.00 when the fields are empty? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide $0.00
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "J" wrote in message ... I tried the first one and it works perfect. Thanks. "T. Valko" wrote: Try one of these: =IF(COUNT(B3,C3)<2,"",B3*C3) =IF(OR(B3="",C3=""),"",B3*C3) -- Biff Microsoft Excel MVP "J" wrote in message ... I am using Excel 2007. I am using the following formula to calculate the total cost based on 2 cells: The formula is in Cell "F3" and is entered as this =B3*C3 How can I keep it from displaying $0.00 when the fields are empty? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide $0.00
And in the spirit of "there are more ways to kill a pig than stuffing it
with butter": Use conditional formatting such that if value is zero, then font color matched cell background and hence is invisible. But I prefer Peo's answer! best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Peo Sjoblom" wrote in message ... Or just a custom format like $#,##0.00;-$#,##0.00; That way the OP can suppress the display of zeros where he/she wants it only and not in the whole workbook -- Regards, Peo Sjoblom "ShaneDevenshire" wrote in message ... Hi J, An alternate solution which might be considered is to suppress the display of zero on the sheet. In that case you hide all 0's from view or printing but they still remain in the cell. This effects the entire sheet on which you apply it. Choose File (Office Button), Excel Options, Advanced, Display options for this worksheet, and uncheck "Show zero in cells that have zero value." -- Cheers, Shane Devenshire "J" wrote: I am using Excel 2007. I am using the following formula to calculate the total cost based on 2 cells: The formula is in Cell "F3" and is entered as this =B3*C3 How can I keep it from displaying $0.00 when the fields are empty? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide $0.00
The easiest IMHO is a simple formula:
=IF(B3*C3,B3*C3,"") Kills 2 birds with one stone.<g -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Bernard Liengme" wrote in message ... And in the spirit of "there are more ways to kill a pig than stuffing it with butter": Use conditional formatting such that if value is zero, then font color matched cell background and hence is invisible. But I prefer Peo's answer! best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Peo Sjoblom" wrote in message ... Or just a custom format like $#,##0.00;-$#,##0.00; That way the OP can suppress the display of zeros where he/she wants it only and not in the whole workbook -- Regards, Peo Sjoblom "ShaneDevenshire" wrote in message ... Hi J, An alternate solution which might be considered is to suppress the display of zero on the sheet. In that case you hide all 0's from view or printing but they still remain in the cell. This effects the entire sheet on which you apply it. Choose File (Office Button), Excel Options, Advanced, Display options for this worksheet, and uncheck "Show zero in cells that have zero value." -- Cheers, Shane Devenshire "J" wrote: I am using Excel 2007. I am using the following formula to calculate the total cost based on 2 cells: The formula is in Cell "F3" and is entered as this =B3*C3 How can I keep it from displaying $0.00 when the fields are empty? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide a pop up | Excel Discussion (Misc queries) | |||
Hide Unhide Hide again | New Users to Excel | |||
HIDE-IF??? | Excel Discussion (Misc queries) | |||
How can I hide #VALUE! | Excel Worksheet Functions | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |