I want to return a value if any of three cells is blank, or contains data for that matter. I'm having an issue with the ISBLANK function containing too many arguments. Here's what I have:
=IF(ISBLANK(F2,J2,K2),No,Yes)
The ISBLANK function only lets me return a value when one cell is referenced, but not multiple.
Please help!
=IF(OR(ISBLANK(F2),ISBLANK(J2),ISBLANK(K2)),"No","Yes")
Regards, TMS
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
Thank to TMS, much appreciated.
You're welcome.
Here's another possibility...
=IF(COUNTA(F2,J2:K2)<3,"No","Yes")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks