In Excel 2010 what would you type as a formula if amounts were charged at an increment level?

Question

if (Cell D3=10,250)

1-10000or less charge at .20,

10,001-300,000 charge at .15.

so if your number is 10,250, 10,000 would be 10,000*.20, and 250 would be at .15? what would the Excel formula be

Answer 1

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.