non nested-if way to change (0) to 0?
 

Thanks for any help.
I have a cell with a formula, and the cell format is number, with
parenthesis for negative numbers. So negative 50 is displayed (50). And I
have set decimal places to 0, so a negative 0.005 is displayed as (0). I
would like anything less than 1 and greater than -1 to just be a 0, not a
(0). I can do that now, with a nested if:
=IF(SHEET1!A1+SHEET2!A1<1,IF(SHEET1!A1+SHEET2!A1-1,0,SHEET1!A1+SHEET2!A1),)
But this seems an inefficient way of doing it, and looks bad, especially
since the formulas are longer, more like
SHEET1!A1+SHEET2!A1+SHEET3!A1+SHEET4!A1. Is there a more elegant way of doing
this?
Thanks again.

In the Tools Options menu there's a setting "Precision as displayed".
Handle it with care.

HTH. Best wishes Harald

"Ian Elliott" skrev i melding
...
Thanks for any help.
I have a cell with a formula, and the cell format is number, with
parenthesis for negative numbers. So negative 50 is displayed (50). And I
have set decimal places to 0, so a negative 0.005 is displayed as (0). I
would like anything less than 1 and greater than -1 to just be a 0, not a
(0). I can do that now, with a nested if:

=IF(SHEET1!A1+SHEET2!A1<1,IF(SHEET1!A1+SHEET2!A1-1,0,SHEET1!A1+SHEET2!A1),)
But this seems an inefficient way of doing it, and looks bad, especially
since the formulas are longer, more like
SHEET1!A1+SHEET2!A1+SHEET3!A1+SHEET4!A1. Is there a more elegant way of
doing
this?
Thanks again.