Question about Microsoft Office Excel 2007

# Need a formula in excel

I have two cells to see is a statement is true so if T2 equals "clark", "skamania", or "clickitat" and the U2 equals "WA" give me a value of x. How would I write this formula?

Posted by on

• Level 1:

An expert who has achieved level 1.

• Contributor

Use if statement
=IF(AND(OR(A1="clark",A1="skamania",A1="clickitat"),B1="WA"),1,0)
where A1=T2 and B1=U2

Posted on Jul 16, 2009

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 in excel 2013 for if statement

Oct 17, 2017 | Excel Computers & Internet

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

### Need an excel formula

This Boolean formula:

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

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

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

### Formula for copy multiple cells at a time

You'll want to use the IF formula, its syntax goes like this: =IF(condition to be met,value if true,value if false)

If you want to use text for the true/false values, you'll need to put the term in quotes.

Example, lets say you want to know if 260+G\$2+F60+\$X\$99+\$A25 is equal to 1024, then the formula would be: =IF(260+G\$2+F60+\$X\$99+\$A25=1024,"True","False")

Dec 29, 2008 | Microsoft Office 2003 Basic Edition...

### Excel formula question

mmm...could be tricky......you could try the argument IF THEN ELSE in the functions list, in conjunction with additional columns to carry out the intermediate calculations, then you can hide those columns. perhaps you could also make use of conditional formatting. any problems come back to me.....could you place a snapshot of the sheet you are designing ? just highlight the cells , copy them, and use edit "paste special", tick values when pasting into this forum.

Jan 18, 2008 | Computers & Internet

### If statement

Hi,

MS Excel's logical test (IF) by its very nature has already two (2) "IF" conditions in a cell, "if true" and "if false".
Should you want to do a series of conditions for a single logical test of a cell, you can replace the IF TRUE and IF FALSE values with other IF Condition(s) (of course the syntax must be correct with appropriate parenthesis where and when required). Formula within a formula within a formula).
Below is an example of four (4) instances of IF conditions within the initial IF formula.

=IF(H7>4.21,H1,(IF(H7>3.4,I1,(IF(H7>2.6,J1,(IF(H7>1.8,M1,(IF(H7>0.99,O1,O7)))))))))

Hope this be of some help/idea. Pls post back how things turned out or should you need additional information.

Good luck and kind regards.

Jan 12, 2008 | Microsoft Office Standard for PC

### Excel 2002 formula

Try this:

=IF((E2<38),B2*14.3, IF((E2<44),B2*15.05, IF((E2<50),B2*15.8,0)))

Note that <38 is the same as <=37. Also, you can replace the 0 at the end with empty quotes "" for a blank cell.

Dec 03, 2007 | Computers & Internet

### Getting the excel formula

Suppose the value for \$ is stored in cell A3. Your formula would look like this: =(A3+A3*0.25)*1.5

The equals sign at the beginning of the formula is necessary. And if you want the result to be formatted as currency, you can do so by right-clicking the cell or column, format cell, number tab, choose currency.

Nov 15, 2007 | Computers & Internet

## Open Questions:

#### Related Topics:

114 people viewed this question

Level 3 Expert

Level 3 Expert