Question about Oracle Database Enterprise Named User Plus

# Formula not working correctly

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.

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

Governor:

An expert whose answer got voted for 20 times.

• Expert

You need to change the =IF(AND to =IF(OR
Using AND is saying both conditions must be true. Using OR is saying either condition 1 or 2 need to be true

Posted on Apr 16, 2009

• Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

• Contributor

Posted on Apr 16, 2009

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)
Goodluck!

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

### I need a formula based on the value of two cells

You were of to a good start. Try using the AND function in the IF Formula as follows:
=IF(AND(Sheet3!H2="Clark College",ISBLANK(Sheet3!I2)),"X"," ")

Apr 15, 2009 | Oracle Database Enterprise Named User Plus

### Excel formula related to a date range

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.
=IF(AND(Sheet3!B1>=Sheet3!C1,(Sheet3!B1<=Sheet3!D1)),"X"," ").
Make sure you type the formula Exactly as it appears.

Mar 20, 2009 | Oracle Database Enterprise Named User Plus

### 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

### VLOOKUP FORMULA PROBLEM

VLOOKUP(A1,Sheet2A2:B20,2,FALSE)

The assumption here is A1 in Sheet 1 is the cell you want to reference, This cell can be pasted - Any problems let me know.

Jan 21, 2009 | 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

### Formaul

you have to use the reference Do you know how to use it

Mar 31, 2008 | Microsoft Excel for PC

### Excel Coordinates don't show up in Formula Bar

Heyo. I have had this problem before too. This procedure prevents the cells that contain the formula from being edited.
1. Select the range of cells whose formulas you want to hide. You can also select the entire sheet.
2. On the Format menu, click Cells, and then click the Protection tab.
3. Select the Hidden check box.
4. Click OK.
5. On the Tools menu, point to Protection, and then click Protect Sheet.
6. Make sure the Protect worksheet and contents of locked cells check box is selected.
Good Luck!
Wayne

Dec 28, 2007 | Computers & Internet

### Formula required

at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks

Dec 04, 2007 | Microsoft Excel for PC

## Open Questions:

#### Related Topics:

135 people viewed this question

Level 1 Expert

Level 2 Expert