Good Morning All,
I need some help on a Formula that is giving me fits. The formula is below, and I've also attached a spreadsheet with sample data.
=IF(C2>25,MIN(INT(C2/3-B2),E2),IF(C2<24,MIN((5-B2),E2)))
Basically it's working perfectly, except in a few cases it's returning a FALSE and I'm not quite sure why.
Book1.xlsx
Thank you!
=IF(C2>25,MIN(INT(C2/3-B2),E2),IF(C2<24,MIN((5-B2),E2)))
In the book you posted, C2 is exactly 25.
So C2>25 = FALSE
It then goes to the 2nd IF
C2<24, this is also FALSE.
But you've omitted the valueiffalse part of the 2nd if.
So it just returns FALSE.
You probalby want
=IF(C2>=25,MIN(INT(C2/3-B2),E2),IF(C2<=24,MIN((5-B2),E2)))
Syntax for an IF condition
=IF(condition, true, false)
It's producing FALSE because you have no "false" result for C2<24,
e.g. If C2 is 24 or 25 both conditions will fail, you have no result for false so you will get FALSE back.
I suspect you have some C2 values between 24 and 25
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Ahh thank you all! Something so simple tripped me up. I appreciate everyone's time this morning.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks