| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wrong amount formula
Excel 2007
The amount to this formula should be 363.04 =(C4*2%+(C415651.89)*(C4-15651.89)*5%) where C4 = 16651.89 I need to find 2% of C4 up to 15651.89 and anything over that (difference) at 5% |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
| Wrong amount or calculation error? | Excel Discussion (Misc queries) | |||
| Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
| SUMPRODUCT is showing wrong Amount | Excel Discussion (Misc queries) | |||
| IF function displays wrong amount | Excel Worksheet Functions | |||
Threaded Mode
