<span>For this IF function, look at cell A1. The logical test asks if the value in A1 is less than 100,000: in this case, the value of 90,000 would be less. If the value in A1 is under 100,000, the value is to be multiplied by 0.05 (5%), and multiplied by 0.075 if it is 100,000 or greater (7.5%). For a value of 90,000 * 0.05, the value that would be displayed in the cell with the IF function would be 4,500.</span>
Use photo math , that will help a lot!!
<span>3/20: 0.15
7/50: 0.14
9/25: 0.36
4/15: 0.266667
1/9: 0.111111
9/40: 0.225
5/16: 0.3125
7/9: 0.777778
13/20: 0.65
37/50: 0.74
11/30: 0.366667
19/40: </span>0.475
