if condition in excel Closed

Question

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.

roja · Accepted Answer

write formula:
=IF(A2="a",100000-(100000*16%),B2)
where A2=cell name representing A or B
100000 is total sales value

prashant · Answer

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

If condition in excel

2 responses

Similar discussions

Subscribe To Our Newsletter!