In Excel I have a document that has 3 sheets on sheet 1 I have the following formula in a cell where I want an "x" =IF(AND(Sheet3!B2>=Sheet3!BU5,(Sheet3!B2<=Sheet3!BV5)),"x", " ")
This is based on a date value, if the birthdate in Sheet3! B2 is greater than or equal to Sheet3!BU5 or if the birthdate in Sheet3!B2 is less than or equal to Sheet3!BV5 put an x in this cell. I'm not sure what I am doing wrong. Thanks for the help.
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!
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
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.
Use the IF and Date functions together. On sheet 3, put the birthday (3/15/1954) in cell B1, put the beginning date (1/1/1946) in cell C1 and the ending date (12/31/1964) in cell D1.
Then on Sheet 1, but the following formula in the cell you want an X to be placed in.
Make sure you type the formula Exactly as it appears.
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
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.