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

Ehow com


There isn't one. Square foot is a unit of area, cubic yard is a unit of volume.

What's the volume in cubic yards of a room that's 10 feet by 12 feet? That depends on how high the ceiling is. Without the third dimension, there is no way to convert.

Jul 07, 2014 | Computers & Internet

1 Answer

I keep getting a box on my screen every time i try to do anything. it says EvalInsandbox:SyntaxError:syntaxerror


Correct a Syntax Error Syntax errors are the most common problem for developers. A single syntax error can cripple even the best applications and websites. You can correct syntax errors easily once you find them. Typical errors include missing commas, semicolons and parenthesis. Debuggers are available in many software development kits to aid you in the location of syntax errors. However, you can find and correct syntax errors manually as well. Learning how to correct syntax errors is an essential part of being a software developer.

Locate the syntax error manually. Step through each section of your code. Most code will be sectioned off into groups or functions. Carefully proof your code. Be sure to pay close attention to how lines are grouped. A common syntax mistake is incorrect grouping.

For instance, if you have an If Else statement embedded in another If Else statement, be sure the embedded statement is surrounded by a separate set of parenthesis or brackets, depending on your language. Double-check notes sections. Notes are only for the developer to see. However, if the syntax isn't correct, the notes may become part of your application, which may not agree with existing code. Ensure the syntax around your notes is correct. Run a debugger if possible. This will make locating errors much easier. A debugger will be found under a menu such as Debug, Run or Tools or as part of your SDK's toolbar. Allow the debugger to run. Errors will be listed at the bottom or right side of your screen. Many debuggers will highlight possible errors in your code as well. A line number, along with the possible error, will be listed in the error message. Locate your syntax error if the debugger isn't correct. Sometimes a debugger will show you where your application stopped working correctly. The syntax error itself may be above or below the line listed in the debugger message. Check all syntax within the surrounding area, especially within the line's function. Run your application after correcting the syntax error. Check every possible function of your application to ensure it works correctly. If you find a problem, double-check the syntax in your code that surrounds the problem area. For instance, if your application has a log-in screen that isn't accepting passwords correctly, check the code for the log-in screen. Remove Syntax Error syntax error typically occurs when the Web page you are loading causes a script error in the browser. This is caused by incorrect code that displays an error message or results in a Web page that does not load correctly. You can remove a syntax error by making a change to the settings of your Web browser. Common Web browsers that can experience this type of error include Internet Explorer, Mozilla Firefox and Safari.
Double-click the "Internet Explorer" icon to open the program. Click the "Tools" drop-down menu and select "Internet Options." This will display the Internet Options window. Go to the "Advanced" tab and scroll down to the "Browsing" section. Remove the check from the box for "Disable script debugging (Internet Explorer)," "Disable script debugging (Other)" and "Display a notification about every script error." Click the "Apply" button to save the changes. Click the "OK" button to close the Internet Options window. Close and restart the Internet Explorer browser for the changes you made to take effect. b> Mozilla Firefox b> Double-click the "Mozilla Firefox" icon to open the program. Type "about:config" into the address bar and press the "Enter" key. Type "dom.max_script_run_time" into the Filter text box and press the "Enter" key. Double-click "dom.max_script_run_time" to display the Enter Integer Value dialog box. Enter a value of "10" or "15" into the text box and click the "OK" button to save the change. Close and then restart the Firefox browser for the change to take effect. b> Safari b> Click the "Safari" icon to open the Web browser. Select the option for "Preferences" from the menu bar. Go to the Advanced tab and click the option for "Show Develop menu in menu bar." Click the option for "Develop" from the menu bar. Click the option for "Disable Runaway JavaScript Timer." Close and re-open the browser for the change to take effect. Hope this helps.

b>

b>

Dec 06, 2012 | Mozilla Firefox

1 Answer

Http://ds.servingsys.com/BurstingRes/CustomScripts/mmConversionTag.js - Syntax Error


This error is server-side, meaning that you this problem should be fixed by the administrator of the website. On my end I see no errors however if there is still a problem try clearing your internet cache.

This link has a guide on how to do that.

Mar 01, 2012 | Microsoft Internet Explorer 8

1 Answer

I have a mac os x and need to download java 1.6 or greater and cannot seem to find one that will download so i can access limewire


Hello,
Below is the link where u can donwload latest version or java
Click Here to download the JAVA.
Please let me know if you have any further questions or concerns.
Thanks.

May 02, 2010 | Apple Computers & Internet

1 Answer

Problem loading Facebook. Page don't show up with graphics.


It isn't Facebook, it is Internet Explorer which Microsoft bundled within their operating system, this is why users of Facebook and Foxnews have repeated problems when using Internet Explorer and it seems the gap is too wide now for Microsoft to catch up. Any respectable programmer now uses Mozilla Firefox as their browser of choice because it allows for more robust applications such as used on Facebook and Foxnews. Microsoft will always be in a catch up of patches and downloads as browser technology continues to advance unless they complete redesign a new stand alone browser to take the place of I.E., but they cannot do that since I.E is tied to the operating system. What a nightmare and terrible decision made years ago by Microsoft which they curse to this day.

Apr 03, 2010 | Microsoft Internet Explorer 8

1 Answer

When using facebook I keep getting this message and a little yellow exclamation mark on bottom left of screen. Syntax error www.facebook.com Line 1 also Syntax error www.facebook.com Code:0...


try this.... go to tools>>>options>>>privacy>>>>(scroll down to) Accept all cookies ............. use google chrome instead of internet explorer if this doesnt work.....

Feb 10, 2010 | Microsoft Internet Explorer 8

1 Answer

Dws1kqxk.css syntax error?


I am guessing you are trying to use farm vallery

There seems to be a worldwide isure that started on the 5st of Nov, there was a new update on the 4th

Check with the makers of game

Nov 08, 2009 | Microsoft Internet Explorer 8

1 Answer

Cannot load office outlook 2003


Try uninstalling Outlook then reinstalling it. Good Luck!

Nov 15, 2008 | Microsoft Office Outlook 2003 for PC

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

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

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