Home 
Search 
Today's Posts 
#1




formulas
I need to create a formula that says if the value is a minus or 0 show 0.00
if there is a positive value show the value. 
#2




Hi
You can do that with formatting or you could use something like: =IF(yourformula<0,0,yourformula)  Andy. "Penfold" wrote in message ... I need to create a formula that says if the value is a minus or 0 show 0.00 if there is a positive value show the value. 
#3




=IF(yourformula<=0,"0.00",yourformula)
 HTH Bob Phillips <Andy B wrote in message ... Hi You can do that with formatting or you could use something like: =IF(yourformula<0,0,yourformula)  Andy. "Penfold" wrote in message ... I need to create a formula that says if the value is a minus or 0 show 0.00 if there is a positive value show the value. 
#4




Bob
I was working on the theory that the cell would be formatted as 0.00, and therefore the formula wouldn't need to check for being zero itself!  Andy. "Bob Phillips" wrote in message ... =IF(yourformula<=0,"0.00",yourformula)  HTH Bob Phillips <Andy B wrote in message ... Hi You can do that with formatting or you could use something like: =IF(yourformula<0,0,yourformula)  Andy. "Penfold" wrote in message ... I need to create a formula that says if the value is a minus or 0 show 0.00 if there is a positive value show the value. 
#5




Suggest that it would be better to consider (to cover result = 0)
=if(resultofyour formula0,resultofyourformula,0) and before copying format to 2 decimal places. If it was my spreadsheet consider using conditional format so that If value < 0 then fontcolour = white If value = 0 then fontvolour = white This means that only results with positive values have any figures showing  Don C "Andy B" wrote: Hi You can do that with formatting or you could use something like: =IF(yourformula<0,0,yourformula)  Andy. "Penfold" wrote in message ... I need to create a formula that says if the value is a minus or 0 show 0.00 if there is a positive value show the value. 
#6




And, just to toss in one more way:
=MAX(0,your formula) "Penfold" wrote: I need to create a formula that says if the value is a minus or 0 show 0.00 if there is a positive value show the value. 
#7




One caveat with using CF and font colour of white is that the value still
exists in the cell and would be summed along with the others.  Andy. "DonCam65" wrote in message ... Suggest that it would be better to consider (to cover result = 0) =if(resultofyour formula0,resultofyourformula,0) and before copying format to 2 decimal places. If it was my spreadsheet consider using conditional format so that If value < 0 then fontcolour = white If value = 0 then fontvolour = white This means that only results with positive values have any figures showing  Don C "Andy B" wrote: Hi You can do that with formatting or you could use something like: =IF(yourformula<0,0,yourformula)  Andy. "Penfold" wrote in message ... I need to create a formula that says if the value is a minus or 0 show 0.00 if there is a positive value show the value. 
#8




Hi Andy,
I feared he wanted different format for 0 and nonzero :) Regards Bob <Andy B wrote in message ... Bob I was working on the theory that the cell would be formatted as 0.00, and therefore the formula wouldn't need to check for being zero itself!  Andy. 
#9




one question is whether just the display needs to be 0.00 or does a cell
referencing the cell need to read 0.00 or the actual value? Formating the cell does not change the value other cells would read as this cells value. the If or max equaitions would be a real zero value "Penfold" wrote: I need to create a formula that says if the value is a minus or 0 show 0.00 if there is a positive value show the value. 
#10




With A1 representing the cell location, the formula is =IF(A10,A1,0)
"Penfold" wrote: I need to create a formula that says if the value is a minus or 0 show 0.00 if there is a positive value show the value. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
paste formulas between workbooks without workbook link  Excel Discussion (Misc queries)  
Help, Urgent Excel Formulas are not calculating  Excel Discussion (Misc queries)  
Problem with named formula's  Excel Worksheet Functions  
How to make Excel run limited number of formulas on a given worksh  Excel Discussion (Misc queries)  
calculating formulas for all workbooks in a folder  Excel Worksheet Functions 