=(E12-100) *IF(E12>=100, 10%, 0%)
decision tree

nesting one if inside another if
=(E12-100) *IF(E12<100, 0%, IF(E12<1000, 10%, 15%))

Excel only lets you nest functions 7 deep

2^7 possibilities, if balance your decision tree right


decision tree were part of AI (artificial intelligence)
expert system

Financial functions
FV
PV
PMT
RATE
time value of money

future value
present value

FV = PV + PV X RATE

idea of compounding
NPER = how many compunding periods this loan is going on

FV = PV + PV X RATE
year 1 FV = PV X (1 + RATE)
year 2 FV = PV X (1 + RATE) X (1 + RATE)
year 3 FV = PV X (1 + RATE) X (1 + RATE) X (1 + RATE)
year NPER FV = PV X (1 + RATE) ^ NPER