excel

1. E14=IF(E14=1,1000000,IF(E14=2,2000000,3000000))
2. G14=IF(E14>5,25000,IF(E14>3,75000,IF(E14>=1,100000)))
3. H14=C14*250
4. I14=D14*250
5. J14=IF(MID(B14,2,1)="a",10,IF(MID(B14,2,1)="b",20,30))
6. K14=F14+H14+I14+J14
7. 14=IF(RIGHT(B14,1)="j",10%*F14,IF(RIGHT(B14,1)="k",15%*F14, IF(RIGHT(B14,1)="l",20%*F14)))
8. M14=25%*F14
9. N14=IF(I14>=40,20,0)
10. O14=(K14-L14-M14+N14)