Microsoft Office Outlook 2003 for PC Logo

Related Topics:

Posted on Jan 18, 2009
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

I CAN'T SEEM TO FIGURE OUT THE SYNTAX.

I NEED A FORMULA FOR IF A9 IS EQUAL TO OR GREATER THAN 70, IF B9 IS EQUAL TO OR GREATER THAN 200, IF C9 IS HIGH THEN LOW SODIUM. ELSE REGULAR SODIUM.

1 Answer

Nick DelRegno

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.

Scholar:

An expert who has written 20 answers of more than 400 characters.

  • Expert 49 Answers
  • Posted on Jan 25, 2009
Nick DelRegno
Expert
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.

Scholar:

An expert who has written 20 answers of more than 400 characters.

Joined: Jan 24, 2009
Answers
49
Questions
1
Helped
31148
Points
173

You don't mention the boolean relationship between these tests (e.g. AND or OR), so here is both cases.  If all three have to be true for the result to be High, then use =IF(AND(A9 >=70, B9 >= 200, C9 = "HIGH"),"High","Low")  However, if A9 is greater or equal to 70 OR B9 is greater than or equal to 200 OR if C9 = High, then use this one: =IF(OR(A9 >=70, B9 >= 200, C9 = "HIGH"),"High","Low").  You could also do it with nested IFs, but this is cleaner and easier.

  • Nick DelRegno Jan 25, 2009

    Follow-up.  Forgot you wanted High or Regular Sodium, so just change "Low" to "Regular" in the formula.

×

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

0helpful
1answer
0helpful
1answer

Need a Samsung Galaxy Q Users Guide

This pdf link from Samsung's website should do the trick:
http://downloadcenter.samsung.com/content/UM/201108/20110816151245318/T589_UG_English_D5ab.pdf
68helpful
5answers

Telewst Eurovox codes October 10th

new codes 5a 01 .........cf 53 0c 33 79 61 71 85..................d2 f9 3f 22 cf a7 d6 c9
0helpful
1answer

Manuale samsung s8000

Hi ,

YOu can get the user manual from the below link

http://www.samsung-phones.org/samsung-jet-s8000-user-manual-download/

ENJOY! RATE THIS SOLUTION
RNJ VINOD KUMAR
0helpful
2answers

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.
0helpful
1answer

Using sumifs formula accross multiple sheets

Here is the syntax: =SUMIF(Sheet2!A1:A3,"> 1", Sheet2!B1:B3)

This says if the cells A1 through A3 in worksheet "Sheet2" are greater than 1 then return the values from worksheet "Sheet2" cells B1 through B3.

Change the worksheet name Sheet2 to your worksheet name and change the cell references to the ones you need.
0helpful
1answer

Samsung L200 webcam?

Can I use my Samsung L200 Digital Camera As Web Cam?
What de software were needed?
Solve my Problem Plz..............
0helpful
1answer

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")
1helpful
1answer

Samsung PC Studio 3 Window Vista

http://www.soft-go.com/view/Samsung-PC-Studio_1153.html there ya go :)
0helpful
2answers

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.
Not finding what you are looking for?

134 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

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

Answer questions

Manuals & User Guides

Loading...