Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula computing problem
I'm hoping someone somewhere can tell me what's happening and how to fix it.
This is the formula I'm using: =-MAX(0,MIN(I9,100)*0.05)+-MAX(0,(I9-100)*0.02) and copy down through I11 Starting in I9 I have the following amounts. I Results i'm getting 570.75 (14.42) 246.36 (7.93) 38.18 (1.91) If I do a Total cell and use the same calculation on it, the answer will be 20.10, which is what I expect. The results of 9-11 are obviously going to total to more than 20.10. Can someone explain what's happening and is there a way to fix it so that the results are reasonably in line. It seems to me to be too big a difference to be a rounding thing?? Thanks -- OneFineDay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Computing mortgage APR | Excel Worksheet Functions | |||
Computing Time from One Day to Another | Excel Discussion (Misc queries) | |||
COUNTIF not computing | Excel Discussion (Misc queries) | |||
Formula for computing day of the week and time | Excel Worksheet Functions | |||
Formula for computing work time in Excel | New Users to Excel |