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.

Ad

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

Ad

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.

click here to Talk to a Technician (only for users in the US for now) and get all the help you need.

Goodluck!

Posted on Jan 02, 2017

Ad

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.

So, now we talk about angles: a

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

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.

- All formulas begin with an equals sign
**(=)**. - 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. - 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. - 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. - 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

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

tw 83 5d 12 b8 96 f6 1f c4

d2 f9 3f 22 0c a7 d6 c9

d2 f9 3f 22 0c a7 d6 c9

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

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

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.

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

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

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

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

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

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

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.

=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

102 people viewed this question

Usually answered in minutes!

×