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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

=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))))