|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 6th, 2008, 03:08 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My rounding error in a simple IF
col:A col:B col:C col
 col:E 4.82 -.02 =4.80 vs 4.80 =0% why am i getting an error here? =if(A0.10,(D-C)*100/C,0) Im expecting a 0% difference between C AND D IT SHOULD READ 0% DOH! WHAT am i doing wrong here? I GET A number anywhere from 0.03% to .09% any tips to do this right? 
|
|
#2
August 6th, 2008, 03:58 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My rounding error in a simple IF
Not quite following you on this...
Does "=4.80" mean that's a calculated value? If so, the 4.80 may not be the true value of that cell. It may be something like 4.80000000056889 You should probably round it off to 2 decimal places. -- Biff Microsoft Excel MVP "garron" wrote in message ... col:A col:B col:C col col:E4.82 -.02 =4.80 vs 4.80 =0% why am i getting an error here? =if(A0.10,(D-C)*100/C,0) Im expecting a 0% difference between C AND D IT SHOULD READ 0% DOH! WHAT am i doing wrong here? I GET A number anywhere from 0.03% to .09% any tips to do this right?
|
|
#3
August 6th, 2008, 04:11 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My rounding error in a simple IF
You should probably round it off to 2 decimal places.
Round it using the ROUND function. Don't just *format* it to show only 2 decimal places. Formatting is only for *display* purposes. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Not quite following you on this... Does "=4.80" mean that's a calculated value? If so, the 4.80 may not be the true value of that cell. It may be something like 4.80000000056889 You should probably round it off to 2 decimal places. -- Biff Microsoft Excel MVP "garron" wrote in message ... col:A col:B col:C col col:E4.82 -.02 =4.80 vs 4.80 =0% why am i getting an error here? =if(A0.10,(D-C)*100/C,0) Im expecting a 0% difference between C AND D IT SHOULD READ 0% DOH! WHAT am i doing wrong here? I GET A number anywhere from 0.03% to .09% any tips to do this right?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
