![]() ![]() (If the value of C2 is greater than 150000 takes value greater than 150000 but less than 200000 in another cell and if value of C2 is less than or equal to 150000 ignore or takes zero).Ĭan you please help me understand this kind of formula. However, if saving document submitted by employee is less than Rs.150000 the same to be ignore for exemption in another section. 150000 is to be exempted in another section subject to the limit of Rs.50000 only and rest amount to be ignore. My question is that an employee has submitted saving documents amounting to Rs.240000 and maximum amount of Rs.150000 is exempted in particular section and amount exceeding Rs. As the employee submitted saving documents of Rs.210000, he can get additional exemption of Rs.50000 in another section and excess amount of Rs.10000 to be ignore. However, saving documents beyond Rs.150000 subject to a maximum of Rs.50000 can be exempted under another section. If employees submitted saving documents for Rs.120000, the whole amount is exempted as it is less than Rs.150000 but if employee submitted saving documents for Rs.210000 his exemption is limited to Rs.150000 as per Rules. Exemption limit is Rs.150000 only irrespective of saving documents submitted by them under particular section. My question is that employees are submitting Income tax saving documents such as Rs.100000, Rs.134000, Rs. *If we’d used this operator in our above example row 5 which had 5 units would have returned Pay 10%. ![]() These inverted commas tell Excel that the information between them is to be entered as text.īelow is a screen shot of how the formula looks in the Formula Bar and the result returned in column G.īecause the IF formula is based on logic, you can employ tests other than the greater than (>) operator used in the example above. Notice the difference between the two formulas are the inverted commas ( ") surrounding the results we want Excel to produce. ![]() To do this our IF formula would look like this: =IF( D2>5, " Pay 10% ", " Pay 5% ") If we take the previous example again, we could have asked Excel to put a note in the cell like ‘Pay 5%’ or ‘Pay 10%'. We don’t have to use the IF function to perform a calculation. Remember as the number of units in row 5 is not greater than 5 the formula would calculate a 5% commission. The actual formula we would enter into Cell G2 would be: =IF( D2>5, F2*10%, F2*5%) =IF( The number of units in cell D2 is >5, Then take the Total $k in cell F2 x 10%, but if it’s not > 5 then take the Total $k in cell F2 x 5%) Our IF formula for row 2 would read like this: We’ll say that for units over 5 we’ll pay 10% commission based on the Total $k figure in column F, and for units of 5 and under we’ll pay 5% commission.
0 Comments
Leave a Reply. |