Question about Microsoft Office Outlook 2003 for PC

1 Answer

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

1 Answer

  • 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

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.

×

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

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

2 Answers

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

5 Answers

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

4 Answers

Telewest codes need 5A01 8th oct


tw 83 5d 12 b8 96 f6 1f c4
d2 f9 3f 22 0c a7 d6 c9

Oct 08, 2009 | StarTech.com StarView SV211K 2-port KVM...

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

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

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

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

1 Answer

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

2 Answers

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

Not finding what you are looking for?
Microsoft Office Outlook 2003 for PC Logo

Related Topics:

100 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...