Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal Places
I have the following formula: =if(C43=Z42,"",(C43-Z42))
Sometimes the cell is blank, other times I have either -0.00 or 0.00 . Further research shows I need to show 8 decimals places or more to get the difference. The cells C43 and Z42 are formulas, but I believe all calculations are formatted for 2 decimal places. How can I increase the formula result to just show differences of of .01 or more? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal Places
try
=if(abs(c43-z42)0.01,c43-Z42,"") "JHL" wrote: I have the following formula: =if(C43=Z42,"",(C43-Z42)) Sometimes the cell is blank, other times I have either -0.00 or 0.00 . Further research shows I need to show 8 decimals places or more to get the difference. The cells C43 and Z42 are formulas, but I believe all calculations are formatted for 2 decimal places. How can I increase the formula result to just show differences of of .01 or more? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal Places
maybe...
=if(abs(C43=Z42)<.01,"",C43-Z42) You may want to add round to the else portion, too: =if(abs(C43=Z42)<.01,"",round(C43-Z42,2)) (or not) JHL wrote: I have the following formula: =if(C43=Z42,"",(C43-Z42)) Sometimes the cell is blank, other times I have either -0.00 or 0.00 . Further research shows I need to show 8 decimals places or more to get the difference. The cells C43 and Z42 are formulas, but I believe all calculations are formatted for 2 decimal places. How can I increase the formula result to just show differences of of .01 or more? Thanks. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal Places
=if(ABS(C43-Z42)<0.01,"",C43-Z42)
-- David Biddulph "JHL" wrote in message ... I have the following formula: =if(C43=Z42,"",(C43-Z42)) Sometimes the cell is blank, other times I have either -0.00 or 0.00 . Further research shows I need to show 8 decimals places or more to get the difference. The cells C43 and Z42 are formulas, but I believe all calculations are formatted for 2 decimal places. How can I increase the formula result to just show differences of of .01 or more? Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal Places
Thanks for all the responses. David's suggestion works best.
Thank you "David Biddulph" wrote: =if(ABS(C43-Z42)<0.01,"",C43-Z42) -- David Biddulph "JHL" wrote in message ... I have the following formula: =if(C43=Z42,"",(C43-Z42)) Sometimes the cell is blank, other times I have either -0.00 or 0.00 . Further research shows I need to show 8 decimals places or more to get the difference. The cells C43 and Z42 are formulas, but I believe all calculations are formatted for 2 decimal places. How can I increase the formula result to just show differences of of .01 or more? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Places | Excel Discussion (Misc queries) | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
decimal places | Excel Discussion (Misc queries) | |||
add 2 decimal places | Excel Discussion (Misc queries) |