Previous Topic Next Topic

If condition in excel

Closed
nadia - May 23, 2009 at 01:37 AM
 prashant - Aug 17, 2010 at 02:26 AM
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.
Related:

2 responses

Answer 1 / 2
roja
Jun 30, 2009 at 01:38 PM
write formula:
=IF(A2="a",100000-(100000*16%),B2)
where A2=cell name representing A or B
100000 is total sales value
7
Answer 2 / 2
prashant
Aug 17, 2010 at 02:26 AM
=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

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses