Question about Microsoft Office Excel 2007
I need a value of x if Sheet3! W2 = Clark College and Sheet3! X2 and Y2 are blank I thought the formula below would work but it isn't. Help!!!
=IF(AND(Sheet3!W2="Clark College",ISBLANK(Sheet3!X2:Y2)),"X"," ")
Try using "count if blank"
I am assuming that you need the value to be on sheet 3
If you want the value to be on another sheet, it is more complicated, you will have to "paste special" the value to a different sheet.
Posted on Jul 22, 2010
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Feb 27, 2010 | Casio FX-7400G Plus Calculator
Aug 18, 2009 | Microsoft Office Excel 2007 Full Version...
Aug 13, 2009 | Microsoft Excel 97 Full Version for PC
Jun 11, 2009 | Microsoft Excel for PC
Apr 15, 2009 | Oracle Database Enterprise Named User Plus
Mar 20, 2009 | Oracle Database Enterprise Named User Plus
97 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: