Multiple IF Statements are working as I would like
In this Spreadsheet I am creating - Here - B9's Formula isThe Cells its referring to are what it should be (B18=FALSE, B19=TRUE and B23=FALSE) But yet it is still displaying No
Please Login or Register to view this content.
Does anyone know why this might be? Is it because there are formulas in those cells that make them say TRUE or FALSE?
ALSO A Screencap: http://gyazo.com/2830a2065c05f2242b04d986b97f759e
Thanks
Remove the quotation marks from the Trues and Falses in all formulas.Please Login or Register to view this content.
Ben Van Johnson
I have simplified some of your formulas, and B9 is now NO. I copied your stuff off to the side so you can compare. Keep in mind that if you have a formula like =x=y, the answer will always ONLY ever be TRUE or FALSE, so there is no need to put it in an IF statement
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks guys, I thought it may have something to do with the formula outputs and they were too complicated
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks