Question about Oracle Database Enterprise Named User Plus

1 Answer

I need a formula based on the value of two cells

In excel I have a document that has three sheets. In sheet3 if cell H2="Clark College" AND I2 is blank I want an "X" in a specific cell on sheet one. Any help would be greatly appreciated.

Posted by on

  • ccfnd girl Apr 15, 2009

    Thank you YOU ROCK!

×

Ad

1 Answer

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

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"," ")

Posted on Apr 15, 2009

Ad

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

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Need formula for Excel


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.

Jul 22, 2010 | Microsoft Office Excel 2007

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

Excel formulas


Below is the formula for "2". The logic should be obvious from this so you can adapt for "1" or a combination of 1 and 2. This need to be written as one long formula so I have pasted it in to this reply so you can do a copy and paste into your spreadsheet. Sorry its not very readable in this form but you could paste into word so you can break it down and examine structure.

=IF(OR((AND(Sheet3!A12="WA",OR(Sheet3!AH2="Lewis",Sheet3!AH2="Pacific",Sheet3!AH2="Wahkiakum"))),(AND(Sheet3!A12="OR",OR(Sheet3!AH2="Clackmas",Sheet3!AH2="Multnomah",Sheet3!AH2="Washington")))),"X"," ")

Aug 18, 2009 | Microsoft Office Excel 2007 Full Version...

1 Answer

Need an excel formula


This Boolean formula:
=(A2="Clark College")*(NOT(ISBLANK(B2))+(C2="Graduate"))

it will return values of 0, 1, or 2 depending upon how many of the conditions are met. This is for A AND (B OR C). [A*(B+C)]. If you mean (A AND B) OR C use the format (A*B)+C.

Aug 13, 2009 | Microsoft Excel 97 Full Version for PC

1 Answer

Need an excel formula.


The crude solution is:
=IF(Sheet3!I2="WA",IF(Sheet3!H2="Vancouver","X",IF(Sheet3!H2="Camas","X",IF(Sheet3!H2="Ridgefield","X",IF(Sheet3!H2="Washougal","X",IF(Sheet3!H2="Stevenson","X",IF(Sheet3!H2="Hockinson","X","?City?")))))),"?State?")

Where ?City? appears when the city referenced in H2 is not part of the lookup
and ?State? appears when something other than WA appears in I2.

But there is probably a better way to do this using an array of valid values like the one below:

AL NY TX WA Birmingham Albany Abilene Camas Huntsville Buffalo Galvaston Hockinson Russell New York Houston Ridgefield Stevenson Vancouver Washougal

In the scenario you could stuff the array in another worksheet and use the HLookup function to find the "Sheet3!I2" value in the first row of this array to determine which column to look in, then VLookup "Sheet3!H2" in the column of that array to see if the city referenced exists. Of course this is a much more complex formula, but it would be easily extendible without changing the formula every time.

For mor info, see "Lookup and Reference Functions" in the Excel Help.

Jun 11, 2009 | Microsoft Excel for PC

2 Answers

Need formula for excel


Well the symbol for greater than would be => and for lesser than would be +<  so if you can incorporate that into your formula it should work. Something like A2=>Sheet3.

Jun 11, 2009 | Microsoft Excel for PC

1 Answer

In Excel trying to compare two ranges


I imagine that the only way is with VBA coding. This is possible if you know programming in Excel (VBA - Visual Basic for Applications).

Apr 17, 2009 | Oracle Database Enterprise Named User Plus

2 Answers

Formula not working correctly


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

Apr 16, 2009 | Oracle Database Enterprise Named User Plus

1 Answer

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

Not finding what you are looking for?
Oracle Database Enterprise Named User Plus Logo

137 people viewed this question

Ask a Question

Usually answered in minutes!

Top Oracle Computers & Internet Experts

CNewton2
CNewton2

Level 1 Expert

27 Answers

cwradio73

Level 3 Expert

1162 Answers

JonSnell Electronic
JonSnell Electronic

Level 3 Expert

23109 Answers

Are you an Oracle Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...