Hello I have the attached excel worksheet that isn't working properly. Basically if the cell in column "A" is blank it should give me a zero, I should only get a "1" as a result if the cell in column B is less than 31....
Hello I have the attached excel worksheet that isn't working properly. Basically if the cell in column "A" is blank it should give me a zero, I should only get a "1" as a result if the cell in column B is less than 31....
Last edited by jgomez; 07-21-2016 at 05:53 PM.
okay so if A2 is blank then 0, if B2>31 then 1, what about the rest when A2 is NOT blank and B2 is LESS than 31?
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
I should get a zero back in that case Mike
Please Login or Register to view this content.
Thank you, I kind of got it on my own but as you can see in some of the columns I get false... any clue as to why?
You are using AND() incorrectly.
Last edited by mikeTRON; 07-21-2016 at 05:48 PM.
Oh, where does it go?
Thank you!
Sure, and take a look at this if you want to learn more about AND.
https://support.office.com/en-us/art...a-ce285a19e9d9
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks