Question about Microsoft Office Outlook 2003 for PC
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.
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
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.
Posted on Jan 02, 2017
Tips for a great answer:
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.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Apr 17, 2009 | Computers & Internet
Dec 29, 2008 | Microsoft Office 2003 Basic Edition...
Jan 18, 2008 | Computers & Internet
100 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: