On My spreadsheet, if cell D12 is NOT(ISBLANK) or in otherwords it has something in it, AND another cell Q12, is ISBLANK, cell p12 should say 1, otherwise 0.
So if cell D12 hasn't got anything in it, or cell Q12 has got something in it, the answer should be 0.
I wrote it like this:
IF(AND(NOT(ISBLANK(D12)),ISBLANK(Q12)),1,0)
Do I need and OR statement too? for the opposite calculation? Ive tried every combination.
=if(and (D12<>"",Q12=""),1,0)
Last edited by mehmetcik; 04-01-2019 at 04:48 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
That works for me.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I was referring to your original formula. That said, I never use ISBLANK and would use mehmetcik's approach.
Thank you so much! I really overthought that! LOL
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks