Question

write the spreadsheet formula:
a. when gross >=20000 but <30000, Bonus is 10%.
b. when gross >=30000but <40000, Bonus is 5%.
c. when gross is >=40000 ,assign Bonus "NIL".​

Answer 1

A. When gross>=20000 but &It;30000, bonus is 10%