formulas

[Guest]

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.

 

[Guest]

Hi
You can do that with formatting or you could use something like:
=IF(yourformula<0,0,yourformula)

 

[Bob Phillips]

=IF(yourformula<=0,"0.00",yourformula)

 

[Guest]

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!

 

[Guest]

Suggest that it would be better to consider (to cover result = 0)
=if(resultofyour formula>0,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


:

Hi
You can do that with formatting or you could use something like:
=IF(yourformula<0,0,yourformula)

 

[Guest]

And, just to toss in one more way:

=MAX(0,your formula)

 

[Guest]

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.

 

[Bob Phillips]

Hi Andy,

I feared he wanted different format for 0 and non-zero

Regards

Bob

 

[Guest]

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

 

[Guest]

With A1 representing the cell location, the formula is =IF(A1>0,A1,0)