Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing "0.00" for formula results
I have a feeling that this is a simple thing...yet I have spent too much time
already trying to figure out this "simple" thing. I have a simple purchase order document set up in Excel 2007. I have a formula in the total cost column that essentially multiples the quantity by the unit cost. I would like the total cost cell for each item to appear blank (yet not remove the formula) if there is nothing entered into the cell for that particular row; however, now, if there is no quantity or unit price entered, the result shows as "0.00." How do I change that view...I can't get those zeros to disappear without deleting the formula as well. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing "0.00" for formula results
Say unit cost in Column D, and quantity in Column E, try something like
this: =If(Or(D2="",E2=""),"",D2*E2) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "kate_suzanne" wrote in message ... I have a feeling that this is a simple thing...yet I have spent too much time already trying to figure out this "simple" thing. I have a simple purchase order document set up in Excel 2007. I have a formula in the total cost column that essentially multiples the quantity by the unit cost. I would like the total cost cell for each item to appear blank (yet not remove the formula) if there is nothing entered into the cell for that particular row; however, now, if there is no quantity or unit price entered, the result shows as "0.00." How do I change that view...I can't get those zeros to disappear without deleting the formula as well. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing "0.00" for formula results
hi
try this. =if(unitcost*quanty = 0,"",unitcost*quantity) if the formula results in 0, the cell will appear blank but will show the results if there is a quantity and unit cost. Regards FSt1 "kate_suzanne" wrote: I have a feeling that this is a simple thing...yet I have spent too much time already trying to figure out this "simple" thing. I have a simple purchase order document set up in Excel 2007. I have a formula in the total cost column that essentially multiples the quantity by the unit cost. I would like the total cost cell for each item to appear blank (yet not remove the formula) if there is nothing entered into the cell for that particular row; however, now, if there is no quantity or unit price entered, the result shows as "0.00." How do I change that view...I can't get those zeros to disappear without deleting the formula as well. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing "0.00" for formula results
Try something like this....
Test the quantity cell to make sure there is in fact an entry. If no quantity is entered leave the total cost cell blank: =IF(COUNT(A1),A1*B1,"") -- Biff Microsoft Excel MVP "kate_suzanne" wrote in message ... I have a feeling that this is a simple thing...yet I have spent too much time already trying to figure out this "simple" thing. I have a simple purchase order document set up in Excel 2007. I have a formula in the total cost column that essentially multiples the quantity by the unit cost. I would like the total cost cell for each item to appear blank (yet not remove the formula) if there is nothing entered into the cell for that particular row; however, now, if there is no quantity or unit price entered, the result shows as "0.00." How do I change that view...I can't get those zeros to disappear without deleting the formula as well. Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing "0.00" for formula results
Maybe you could modify the formula:
If you have to have column A and column B in your calculations, you could use: =if(or(a1="",b1=""),"",a1+b1) (for instance) (If either is blank, then show blank. Else do the add. kate_suzanne wrote: I have a feeling that this is a simple thing...yet I have spent too much time already trying to figure out this "simple" thing. I have a simple purchase order document set up in Excel 2007. I have a formula in the total cost column that essentially multiples the quantity by the unit cost. I would like the total cost cell for each item to appear blank (yet not remove the formula) if there is nothing entered into the cell for that particular row; however, now, if there is no quantity or unit price entered, the result shows as "0.00." How do I change that view...I can't get those zeros to disappear without deleting the formula as well. Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Data entry "+" results in "294" in XLS | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
conditional formula to show "open" or "closed" | Excel Worksheet Functions |