An expert who has achieved level 2 by getting 100 points
An expert that got 5 achievements.
An expert whose answer got voted for 20 times.
An expert who has written 20 answers of more than 400 characters.
Re: i CAN'T SEEM TO FIGURE OUT THE SYNTAX.
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.
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!
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
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.
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.
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.