Question about Microsoft Office Outlook 2003 for PC

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

Posted by on

• 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

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.

Posted on Jan 25, 2009

• Nick DelRegno Jan 25, 2009

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

×

Hi,
a 6ya Technician 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 repair professionals here in the US.
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### How can you classify a triangle according to it angle? is there a formula for it

Well, there is classification by sides, equilateral with 3 equal sides, Isosceles with two equal sides, and scalene with no equal sides, but you talk about angles, but I wanted to point out equilaterals have 3 equal angles, isoceles have 2 equal angles and scalene have no equal angles.
So, now we talk about angles: a Right trianlge has one angle that is 90 degrees, an Obtuse triangle has one angle greater than 90 degrees, and an Acute has no angles over 90 degrees.
Thus, it is possible to have a (scalene or isoceles) AND (acute, obtuse, or right) triangle, but never an equilateral AND (obtuse or right). The angles can't be equal and 90+ degrees if all three must equal 180 degrees.

Oct 06, 2012 | Mathsoft StudyWorks! Middle School Deluxe...

### What are the formulas in grading the grades uisng microsoft excel

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

1. All formulas begin with an equals sign (=).
2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
3. Other formulas refer to different functions such as SUM, AVERAGE and others.
For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
4. Formulas can be combined with operands.
For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
5. Functions can be nested within each other.
For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

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

Oct 09, 2009 | Televison & Video

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

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

Apr 17, 2009 | Computers & Internet

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

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

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

## Open Questions:

#### Related Topics:

102 people viewed this question

Level 3 Expert

Level 3 Expert