Question about Microsoft EXCEL 2004 for Mac

1 Answer

Applying "IF" If,'A' is greater than 66,Then K(say) = A*300 'A' greater 50, but less than 66, K=A*200 'A' less than 50 ,Then K=10000 Then how to use 'if ' function to find K

Posted by on

  • chumthungokh Feb 24, 2009

    If,'A' is greater than 66,Then K(say) = A*300
    'A' greater 50, but less than 66, K=A*200
    'A' less than 50 ,Then K=10000

    Then how to use 'if ' function to find K

×

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.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 67 Answers

=IF(K>50,(IF(K>66,A*300,A*200),10000))

Posted on Feb 24, 2009

  • bsevinc Feb 24, 2009

    Correction on the formula...
    =IF(A>50,(IF(A>66,A*300,A*200)),10000)


  • bsevinc Feb 24, 2009

    Just to let you know this is not visual basic or C++, so A and K must represent the cells in the excel. In example cell A1 could be your variable A and cell A2 is the solution K. In this case you need to put your formula in the cell A2 as:
    =IF(A1>50,(IF(A1>66,A1*300,A1*200)),10000)

    Once you put the formula, according to what you put in the cell A1, the result will show on the cell A2.


×

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:

1 Answer

A number greater than -5 but less than or equal to 5


Greater than -5, means infinitely close to -5, but greater than it, so it is on the right hand side of it. On a number line, we indicate this with an open circle at -5.

Less than or equal to 5 means 5 and everything less than 5. On a number line, we indicate this by drawing a circle at 5 and filling it in.

O------------------------------------•

Sorry, I couldn't find a filled in circle to be the same size as the capital o;)

Good luck,

Paul

Dec 08, 2016 | Office Equipment & Supplies

1 Answer

I need help on homework of greater than less than or equal than.


In mathematics, if there are 2 numbers being looked at as an inequality, the greater-than symbol usually goes in between the two and symbolizes that the first number is greater than the second number (For example: 4 > 2, or 102 > 100).

Greater-than sign - Wikipedia

https://en.wikipedia.org/wiki/Greater-than_sign greater than less than or equal than Google Search

Dec 01, 2016 | Computers & Internet

2 Answers

Does the symbols stand for greater than or less than


This is 'greater than' >, eg X is greater than 3......... X > 3

This is 'less than' <, eg Y is less than 3......... Y < 3
.

Jan 13, 2016 | The Learning Company Achieve! Math &...

1 Answer

AC WILL NOT TURN ON WILL RUN BY USING SCAN TOOL


{: ) When an A/C mode is selected, the A/C control head or the A/C programmer supplies a 12 volt signal to the PCM A/C request input. The A/C compressor clutch relay is controlled by the PCM. The PCM provides a ground path for the A/C relay coil. When the A/C compressor relay is engaged battery voltage is supplied to the compressor clutch coil. The PCM will enable the A/C compressor clutch whenever the engine is running and the A/C has been requested unless one or more of the following conditions are present:
Throttle angle greater than 90 %.
• A/C head pressure greater than 414 psi (4.27 volts) or less than 34 psi (0.35 volt) (as determined by the A/C refrigerant pressure sensor). • Ignition 1 voltage below 10.5 volts. • Engine speed greater than 4500 RPM for longer than 5 seconds. • Engine speed greater then 5400 RPM for any amount of time. • ECT greater than 125°C (257°F). • IAT less than 5°C (41°F). • Throttle angle is greater than 90%. • A/C head pressure is greater than 414 psi (4.27 volts) or less than 34 psi (0.35 volt) (as determined by the A/C refrigerant pressure sensor). • Ignition 1 voltage is below 10.5 volts. • Engine speed is greater than 4500 RPM for longer than 5 seconds. • Engine speed is greater then 5400 RPM for any amount of time. • ECT is greater than 125°C (257°F). • IAT is less than 5°C (41°F). Any of the conditions described above will inhibit A/C compressor relay operation.

A scan tool can control a/c operation without regards to the prevailing parameters that can inhibit its functions. Remember that the scan tool is a very effective diagnostic tool.
In this case, the scan tool was able to control a/c, which is an indication that the PCM is communicating, and that circuit 459 going to the relay and then to the a/c compressor are normally functional. You need to check now if the sensor input signals are within the specified ranges.

Jul 06, 2011 | 1997 Chevrolet Venture

1 Answer

Solution for "in math what


Hi,
9>2 (Nine is greater than 2) 1<5 (one is less than 5) 5>1 (five is greater than 1)
Hope it helps! Good Luck! Thanks for using Fixya! CreativeTECH

Jun 21, 2011 | Computers & Internet

1 Answer

Where are my less than and greater than signs on my TI-84 Silver Edition calculator?


Hello.

The less than and greater than signs are above the "(" and ")" keys.

Hope this helps.

Apr 11, 2010 | Texas Instruments TI-84 Plus Silver...

Not finding what you are looking for?
Microsoft EXCEL 2004 for Mac Logo

Related Topics:

87 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18385 Answers

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

Answer questions

Manuals & User Guides

Loading...