Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Change Color - Need Help | New Users to Excel | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
How do I link two cells as to allow me to change the value in eit. | Excel Discussion (Misc queries) | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) |