Nested if problem
Closed
abidaidbr9
Posts
1
Registration date
Tuesday October 8, 2013
Status
Member
Last seen
October 8, 2013
-
Oct 8, 2013 at 06:42 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 8, 2013 at 07:14 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 8, 2013 at 07:14 AM
Related:
- Nested if problem
- How many nested if statements in excel - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 8, 2013 at 07:12 AM
Oct 8, 2013 at 07:12 AM
quote
IF Salary is less than 5001-10800
unquote
this does not mean anything
you mean salaray >=5001 and <10800
rewrite you conditiona
if salary is entered in A1
try this formula
=IF(A1<5000,MAX(2500,A1*0.55),IF(AND(A1>5000,A1<=10800),MAX(2800,A1*0.5),IF(AND(A1>10600,A1<=21600),MAX(5400,A1*0.45),IF(A1>21600,MAX(9700,A1*0.4)))))
modify to suity where you entered salary
IF Salary is less than 5001-10800
unquote
this does not mean anything
you mean salaray >=5001 and <10800
rewrite you conditiona
if salary is entered in A1
try this formula
=IF(A1<5000,MAX(2500,A1*0.55),IF(AND(A1>5000,A1<=10800),MAX(2800,A1*0.5),IF(AND(A1>10600,A1<=21600),MAX(5400,A1*0.45),IF(A1>21600,MAX(9700,A1*0.4)))))
modify to suity where you entered salary
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 8, 2013 at 07:14 AM
Oct 8, 2013 at 07:14 AM
abidaidbr9, Good morning.
To answer exactly what you asked I suggest you use:
=IF(B25<5000,MAX(2500,B25*55%),IF(AND(10800>=B25,B25>5000),MAX(2800,B25*50%),IF(AND(21600>=B25,B25>10800),MAX(5400,B25*45%),IF(B25>21600,MAX(9700,B25*40%),""))))
BUT, if you create a table with your data, it will be easier and pratical when you need to change data or to know the rules.
In this case you will just use VLOOKUP function.
It's just a suggestion.
Tell us if it worked for you.
Greetings from Brazil.
Best regards.
To answer exactly what you asked I suggest you use:
=IF(B25<5000,MAX(2500,B25*55%),IF(AND(10800>=B25,B25>5000),MAX(2800,B25*50%),IF(AND(21600>=B25,B25>10800),MAX(5400,B25*45%),IF(B25>21600,MAX(9700,B25*40%),""))))
BUT, if you create a table with your data, it will be easier and pratical when you need to change data or to know the rules.
In this case you will just use VLOOKUP function.
It's just a suggestion.
Tell us if it worked for you.
Greetings from Brazil.
Best regards.
