Question about Microsoft Excel for PC

2 Answers

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

2 Answers

  • 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
  • 52 Answers

=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
  • 98 Answers

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

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

1 Answer

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

4 Answers

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

4 Answers

How to connect one sheet to another sheet


how i connect one excel sheet to another excel

Dec 21, 2008 | Microsoft Office Excel 2003 for PC

1 Answer

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

2 Answers

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

2 Answers

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

2 Answers

Formula for calculating the days beween months


for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

2 Answers

Excel-formula


how to protect some cells on excel sheet
Dipak

Aug 11, 2008 | Microsoft Excel for PC

4 Answers

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

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

88 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2720 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18391 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...