If condition in excel

Closed
Report
-
 prashant -
Hello,
i want to implement the IF condition in Excel,the logic is if my sales entry is of A type then dedudct 16%sales tax on total sale and if my sales entry is of B type then deduct nothing.

2 replies

write formula:
=IF(A2="a",100000-(100000*16%),B2)
where A2=cell name representing A or B
100000 is total sales value
7
=IF(AND(J8="Platinum",BF8>=BG8),BF*2%,IF(AND(J8="Gold",BF8>=BG8),BF*1.75%,IF(AND(J8="Silver",BF8>=BG8),BF*1.5%,IF(AND(J8="Select",BF8>=BG8),BF*1%,0))))
3