Question about Microsoft Excel for PC

# Need to have a certain cell say OFF when it is a certain day

I need an IF formula for an Excel sheet i'm working on. the one i had is =if(a1=''Saturday'',''off'',''''). the problem is, A1 contains =A2 because A2 is a date. I need A1 to show the day for that date. I just want a certain cell to show OFF if it is a certain day. The one I know only works if I put in the day of week manually. Please help.

Posted by on

• Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

Greenhorn:

A rookie expert who has answered 20 questions on their first day.

Night Owl:

An expert who has answered 10 or more questions between 12 midnight and 6am on the same day.

• Contributor

=weekday(a2) will give you the actual day of the week of the specified date

Posted on Oct 23, 2012

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Governor:

An expert whose answer got voted for 20 times.

Teacher:

An expert who has written 2 tips or uploaded 1 video tip.

• Expert

Use the test function.
Formula in cell A1 would be =text(a2,"dddd").
This would pick up the date from cell A2 and return the day of the week in cell A1.

Posted on Jul 22, 2010

Hi there,
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

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### Formula for cell that is not blank

You can use IF and ISBLANK. Put this formula on Sheet 1 D1:

=IF(ISBLANK(Sheet3!AM2),"x","")

You can replace "x" by any other value you need.

Mar 04, 2010 | Microsoft Excel for PC

### Want to copy formula into multiple excel sheets

why not? however, you can also insert an apostrophe (') at the start of the equation before copying the entire formula so that the formula will be treated as a text thus preserving all cell references. dont forget to remove the apostrophes after you have pasted them though for the formulas to work again.

Jul 29, 2009 | Computers & Internet

### Not able to scroll on my excel sheet

It's only in Excel you can't scroll? Can you scroll from side to side? If you have Excel 2003, try to press the "window" tab on the top and if the freeze pane is checked, uncheck it. Or if it says unfreeze pane, press that one. Hope this helps :)

Jul 20, 2009 | IBM ThinkPad T42 Notebook

### How to use vlookup in openoffice using different sheets

=VLOOKUP(A2;Sheet1.\$A\$3:D27;2;0)

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets
A2 is the cell I want to look up
Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the \$
2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns
0 is the value to complete the formula

Feb 11, 2009 | Microsoft Excel for PC

### Need a formula for excel

select CONDITIONAL FORMATING in Format

select FORMULA IS , CELL VALUE = > < (condition)

after this select Format

font style , COLOR

SEE IT WILL WORK CHANGE OF COLOURS ........

Oct 10, 2008 | Microsoft Excel for PC

### Excel

Highlight the cells you want to format. Move the mouse to the highlighted area, press the right mouse button and make sure the locked option is on under the protection tab.

Make sure protect sheet is enabled. To activate it, press the review under the menu options and select protect sheet (if its on sheet) or workbook for more than one sheet.

Sep 15, 2008 | Microsoft Excel for PC

### Excel formulas

type in "=" and then go to the cell in the 2nd sheet and click on the cell that contains the value you want carried to sheet 1. Then drag copy the forumula in sheet 1 to all the cells you want it to relate to. Now, if you place a value in e.g. A1 of sheet 2, then that same value will appear in A1 of sheet 1.
Good luck.

Sep 13, 2008 | Microsoft Computers & Internet

### Excel-formula

how to protect some cells on excel sheet
Dipak

Aug 11, 2008 | Microsoft Excel for PC

### Excel formula

CHOSE THE PERTICULAR CELL WHERE THE SUM IS GOING TO BE DISPLAYED AND HYPERLINK IT IT WITH SHEET 2

Apr 12, 2008 | Microsoft Excel for PC

#### Related Topics:

90 people viewed this question

Level 3 Expert

Level 3 Expert