Question: In Excel 2010 what would you type as a formula if amounts were charged at an increment level?
Assume that your data is in cell D3 and you you wish the incremented value to be in cell G3.
The syntax for the if-statement in Excel is,
IF(logical_test, value_if_true, [value_if_false])
where
logical test is: "D3<10000"
value_if_true is: D3*1.2
[value_if_false] is: (D3-10000)*1.15+12000
Enter a number in cell D3.
Highlight (click on) the cell G3 and enter the following formula,
"=IF(D3<10000,D3*1.2,(D3-10000)*1.15+12000)" - excluding the quote marks.
Enter a series of numerical values in cells D4 - D8, with some values < 10,000 and some values > 10,000.
Highlight cell G3.
Copy cell G3 and paste it into the 5 cells beneath it. G4 - G8.
Obverse (and check) the results.