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
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.
Here's a link to this great service
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: