IF Formula in Excel returning FALSE on 26.00% >= 10.01%
up vote
0
down vote
favorite
Excel if formula - Getting 0 instead of 75
Why the given IF Formula is evaluating to FALSE? Need help with this formula
Details are in the screenshot!
Screenshot Here
excel excel-formula
asked Nov 10 at 16:26
Asim Khan
133
add a comment |
up vote
0
down vote
favorite
Excel if formula - Getting 0 instead of 75
Why the given IF Formula is evaluating to FALSE? Need help with this formula
Details are in the screenshot!
Screenshot Here
excel excel-formula
asked Nov 10 at 16:26
Asim Khan
133
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
Excel if formula - Getting 0 instead of 75
Why the given IF Formula is evaluating to FALSE? Need help with this formula
Details are in the screenshot!
Screenshot Here
excel excel-formula
asked Nov 10 at 16:26
Asim Khan
133
Excel if formula - Getting 0 instead of 75
Why the given IF Formula is evaluating to FALSE? Need help with this formula
Details are in the screenshot!
Screenshot Here
excel excel-formula
excel excel-formula
asked Nov 10 at 16:26
Asim Khan
133
asked Nov 10 at 16:26
Asim Khan
133
asked Nov 10 at 16:26
Asim Khan
133
asked Nov 10 at 16:26
Asim Khan
133
asked Nov 10 at 16:26
Asim Khan
133
133
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
up vote
0
down vote
It looks like there are inconsistent cell types. Try to format all values as "percentage". Maybe some values are just formatted as string, then the comparisson fails, or the values are as normal floating point values. Please not e that "10%" is just a percentage representation of the fixed value 0.1
answered Nov 10 at 16:33
user287107
7,50112243
add a comment |
up vote
0
down vote
Might be brackets.. otherwise is your data. Double check that the values are not stored as text.
=IF(AND(D7<=D11,D7>=D10),C5,IF(D7<=D9,C4,IF(AND(D7<=D13,D7>=D12),C6,IF(AND(D7>=D14,D7<=D15),C7,IF(AND(D7>=D16,D7<=D17),C8,IF(AND(D7>=D18),C9))))))
answered Nov 10 at 16:45
Wizhi
3,2811730
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
It looks like there are inconsistent cell types. Try to format all values as "percentage". Maybe some values are just formatted as string, then the comparisson fails, or the values are as normal floating point values. Please not e that "10%" is just a percentage representation of the fixed value 0.1
answered Nov 10 at 16:33
user287107
7,50112243
add a comment |
up vote
0
down vote
It looks like there are inconsistent cell types. Try to format all values as "percentage". Maybe some values are just formatted as string, then the comparisson fails, or the values are as normal floating point values. Please not e that "10%" is just a percentage representation of the fixed value 0.1
answered Nov 10 at 16:33
user287107
7,50112243
add a comment |
up vote
0
down vote
up vote
0
down vote
It looks like there are inconsistent cell types. Try to format all values as "percentage". Maybe some values are just formatted as string, then the comparisson fails, or the values are as normal floating point values. Please not e that "10%" is just a percentage representation of the fixed value 0.1
answered Nov 10 at 16:33
user287107
7,50112243
It looks like there are inconsistent cell types. Try to format all values as "percentage". Maybe some values are just formatted as string, then the comparisson fails, or the values are as normal floating point values. Please not e that "10%" is just a percentage representation of the fixed value 0.1
answered Nov 10 at 16:33
user287107
7,50112243
answered Nov 10 at 16:33
user287107
7,50112243
answered Nov 10 at 16:33
user287107
7,50112243
answered Nov 10 at 16:33
user287107
7,50112243
7,50112243
add a comment |
add a comment |
up vote
0
down vote
Might be brackets.. otherwise is your data. Double check that the values are not stored as text.
=IF(AND(D7<=D11,D7>=D10),C5,IF(D7<=D9,C4,IF(AND(D7<=D13,D7>=D12),C6,IF(AND(D7>=D14,D7<=D15),C7,IF(AND(D7>=D16,D7<=D17),C8,IF(AND(D7>=D18),C9))))))
answered Nov 10 at 16:45
Wizhi
3,2811730
add a comment |
up vote
0
down vote
Might be brackets.. otherwise is your data. Double check that the values are not stored as text.
=IF(AND(D7<=D11,D7>=D10),C5,IF(D7<=D9,C4,IF(AND(D7<=D13,D7>=D12),C6,IF(AND(D7>=D14,D7<=D15),C7,IF(AND(D7>=D16,D7<=D17),C8,IF(AND(D7>=D18),C9))))))
answered Nov 10 at 16:45
Wizhi
3,2811730
add a comment |
up vote
0
down vote
up vote
0
down vote
Might be brackets.. otherwise is your data. Double check that the values are not stored as text.
=IF(AND(D7<=D11,D7>=D10),C5,IF(D7<=D9,C4,IF(AND(D7<=D13,D7>=D12),C6,IF(AND(D7>=D14,D7<=D15),C7,IF(AND(D7>=D16,D7<=D17),C8,IF(AND(D7>=D18),C9))))))
answered Nov 10 at 16:45
Wizhi
3,2811730
Might be brackets.. otherwise is your data. Double check that the values are not stored as text.
=IF(AND(D7<=D11,D7>=D10),C5,IF(D7<=D9,C4,IF(AND(D7<=D13,D7>=D12),C6,IF(AND(D7>=D14,D7<=D15),C7,IF(AND(D7>=D16,D7<=D17),C8,IF(AND(D7>=D18),C9))))))
answered Nov 10 at 16:45
Wizhi
3,2811730
answered Nov 10 at 16:45
Wizhi
3,2811730
answered Nov 10 at 16:45
Wizhi
3,2811730
answered Nov 10 at 16:45
Wizhi
3,2811730
3,2811730
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53240970%2fif-formula-in-excel-returning-false-on-26-00-10-01%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
