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. Excel for Decision Making Under Uncertainty Course.Excel for Customer Service Professionals.Now, let's perform a check and output something other than TRUE or FALSE. You can see that checking text works just like checking numbers and you can also see that this check is case insensitive, which means that it does not matter if text is upper case or lower case or mixed case, it can still match. In this example, I will use cell references in the AND function instead of hard coding the values into the function. Here, we will compare text as well as numbers. You can see the logical operators that you can use and that you can have multiple logical tests or arguments or just 1.
The values in column A are all displayed in column B. Here, I want to show you how the function works by testing out numbers and making simple tests so you can better understand how this works. You can have up to 255 conditions in this function if you are in Excel 2007 or later.Įach argument must evaluate to either TRUE or FALSE in order for this function to work.
This would be another condition that you wanted to check to see if it evaluated to TRUE or FALSE. You do not need more than this 1 argument in the function. This is the first argument or condition that you want to check to see if it evaluates to TRUE or not.
0 kommentar(er)
