Nested IF Statement returning False
Hi,
I'm facing a problem in getting the desired result in a nested IF statement. My problem is summarized as under:
1) F27>=40% K27*4500
2) F27>=30% K27*4000
3) D44=C44 & D45=C45
I have arrived at the formula =IF(AND($D$44=$C$44,$D$45=$C$45),IF(F27>=40%,K27*4500,IF(F27>=30%,K27*4000,0))) but getting the result as False.
Kindly help to get the desired result.
Formula is OK: ensure F27 is formatted as %
=IF(AND($D$44=$C$44,$D$45=$C$45),IF(F27>=40%,K27*4500,IF(F27>=30%,K27*4000,0)),"")
Last edited by JohnTopley; 12-14-2016 at 02:03 PM.
Another way, assuming values in C44:D45 are numbers
=IF(SUM(C44:C45)=SUM(D44:D45),K27*LOOKUP(F27,{0,0.3,0.4},{0,4000,45000}),0)
Since D44 and D45 must match C44 and C45, they should have matching sums
If C44:D45 are not numbers
=IF(AND(D44=C44,D45=C45),K27*LOOKUP(F27,{0,0.3,0.4},{0,4000,45000}),0)
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks