Nested if function

[nasar_2016]

I need to resolve a nested if function. The requirement is I have basic salary, grade and the ceiling value and need to calculate the TRA based on the conditions. If the grade is less than 12 and the 10% basic is more than 1000 then the TRA is 1000 else 10% basic. If the grade is greater than or equal to 12, and the 10% basic is more than 2000 then the TRA should be 2000 else 10% of basic. Can anyone help me to resolve this by using if function (with or without AND/OR etc.,)? Thanks.

[easyexcelanswers]

try this
=IF(IF(AND(A2<12, (0.1*B2)>1000), 1000, (0.1*B2)), IF(AND(A2>=12, (0.1*B2)>2000), 2000, (0.1*B2)))

view my video of if with and

https://www.youtube.com/watch?v=a66rYNJWi-w

[JohnTopley]

Misread requirement

[Aardigspook]

Welcome to the forum.

If I understand you correctly, you want this:
If the grade is less than 12 AND 10% of basic salary is greater than or equal to 1000, then TRA is 1000, otherwise it's 10% of basic salary.
If the grade is equal to or greater than 12 AND 10% of basic salary is greater than or equal to 2000, then TRA is 2000, otherwise it's 10% of basic salary.
If that's correct, then this should work:

Please Login or Register  to view this content.

Edit: A2 = basic salary, B2 = grade

[easyexcelanswers]

if neither condition

=iferror(IF(IF(AND(A2<12, (0.1*B2)>1000), 1000, (0.1*B2)), IF(AND(A2>=12, (0.1*B2)>2000), 2000, (0.1*B2))), "not correct")