Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with an equation
Is there a way to not have the answer to an equation show in a cell.?
An exaple of what I have now is cell D1 contains: =B1*C1 , and I dont want anything to show in D1 until something is put into B1 and C1. It shows '$ -' right now and I just want it to be blank. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with an equation
=IF(B1*C1=0,"",B1*C1)
Will show nothing until a value is available. "Jeff" wrote: Is there a way to not have the answer to an equation show in a cell.? An exaple of what I have now is cell D1 contains: =B1*C1 , and I dont want anything to show in D1 until something is put into B1 and C1. It shows '$ -' right now and I just want it to be blank. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with an equation
=if(count(b1:c1)=2,B1*C1,"")
BTW - we talk of 'formulas' not 'equations' - the later have something on both sides of the = best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Jeff" wrote in message ... Is there a way to not have the answer to an equation show in a cell.? An exaple of what I have now is cell D1 contains: =B1*C1 , and I dont want anything to show in D1 until something is put into B1 and C1. It shows '$ -' right now and I just want it to be blank. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with an equation
=IF(OR(B1="",C1=""),"",B1*C1)
"Jeff" wrote in message ... Is there a way to not have the answer to an equation show in a cell.? An exaple of what I have now is cell D1 contains: =B1*C1 , and I dont want anything to show in D1 until something is put into B1 and C1. It shows '$ -' right now and I just want it to be blank. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with an equation
You could check for either cell:
=if(b1="","",b1*c1) or =if(c1="","",b1*c1) or you could check for numbers in both cells: =if(count(b1:c1)<2,"",b1*c1) I bet you clicked the $ icon on the toolbar to format the cell as Currency Style (Accounting format). This is the same as a custom format of: _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_) You could hide the 0's by using: _($* #,##0.00_);_($* (#,##0.00);;_(@_) But this will hide the 0's if either b1 or c1 is 0. Jeff wrote: Is there a way to not have the answer to an equation show in a cell.? An exaple of what I have now is cell D1 contains: =B1*C1 , and I dont want anything to show in D1 until something is put into B1 and C1. It shows '$ -' right now and I just want it to be blank. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NEED EQUATION PLEASE | Excel Worksheet Functions | |||
if equation | Excel Worksheet Functions | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
Equation | Excel Discussion (Misc queries) | |||
help with equation | Excel Discussion (Misc queries) |