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

×

Ad

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.


×

Ad

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.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

4 Answers

For age 52 whats my normal blood pressure


A normal Blood pressure for a 52 year-old male is less than 120/80 mmHg.
A Blood pressure reading between 120-139/80-89 is considered pre-hypertension, and greater than 140/90 Is hypertension (High Blood pressure).

Mar 17, 2017 | Health & Beauty

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

1 Answer

08 avalanche power steps have no power fuse good


Do you know there is a electronic control module for the power steps ? assist step control module !

Circuit/System Description
The assist step control module (ASC) controls the assist step actuators to extend or retract the assist steps. Each actuator consists of an electric motor and a potentiometer. The module supplies a low reference and 10-volt reference source voltage to the potentiometer. The ASC module monitors the voltage drop across the potentiometer on the position signal circuit. When the actuator shaft rotates, the voltage on the position signal circuit changes. The ASC module supplies the actuator motor with a 12-volt control circuit and a ground control circuit. The ASC module controls the direction of the actuator by changing the polarity of the control circuits.

Do you know how to test electric circuits with a DVOM ?
Circuit/System Testing
ASC Disable Switch Circuit Test
Ignition OFF, disconnect the harness connector at the IP multifunction switch.
Test for less than 10 ohms between the listed ground circuit terminal and ground.
• X88/Z88 Terminal 3
• Z75 terminal 1
? If greater than the specified range, test the ground circuit for an open/high resistance.
Ignition ON, verify the scan tool ASC Disable Switch parameter is Inactive.
? If not the specified value, test the signal circuit terminal 9 for a short to ground. If the circuit tests normal, replace the ASC module.
Install a 3A fused jumper wire between the signal circuit terminal 9 and ground. Verify the scan tool ASC Disable Switch parameter is Active.
? If not the specified value, test the signal circuit for a short to voltage or an open/high resistance. If the circuit tests normal, replace the ASC module.
If all circuits test normal, test or replace the IP multifunction switch.
ASC Actuator Circuit Test
Ignition OFF, disconnect the harness connector at the appropriate actuator.
Scan tool disconnected, test for less than 20 ohms between the low reference circuit terminal C and ground.
? If greater than the specified range, test the low reference circuit for an open/high resistance. If the circuit tests normal, replace the ASC module.
Ignition ON, command the appropriate actuator with a scan tool while using the DMM Min/Max function to capture voltage. Test for greater than 9 volts between the 10-volt reference circuit terminal D and ground.
? If less than the specified range, test the 10-volt reference circuit for a short to ground or an open/high resistance. If the circuit tests normal, replace the ASC module.
Command the appropriate actuator with a scan tool while using the DMM Min/Max function to capture voltage. Test for greater than 9 volts between the signal circuit terminal E and ground.
? If less than the specified range, test the signal circuit for a short to ground or an open/high resistance. If the circuit tests normal, replace the ASC module.
Using a scan tool, command the appropriate actuator both directions while using the DMM Min/Max function to capture voltage. Test for greater than 2 volts between the control circuit terminal A and ground.
? If less than the specified range, test the control circuit for a short to ground or an open/high resistance. If the circuit tests normal, replace the ASC module.
Using a scan tool, command the appropriate actuator both directions while using the DMM Min/Max function to capture voltage. Test for greater than 2 volts between the control circuit terminal B and ground.
? If less than the specified range, test the control circuit for a short to ground or an open/high resistance. If the circuit tests normal, replace the ASC module.
If all circuits test normal, replace the ASC actuator.

Nov 24, 2016 | Cars & Trucks

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

I want to graph an inequality but when i got to apps all it shows up is only finance


You don't need an app. Just press the Y= button and enter the inequality as if you're entering another function to be graphed. Then press left-arrow repeatedly to move to the diagonal line at the left end of the display. Press ENTER repeatedly to cycle through the different graph styles. If the inequality is of the form "y less than" or "y less than or equal to", select the shaded triangle below the line. If the inequality is of the form "y greater than" or "y greater than or equal to", select the shaded triangle above the line.

Jun 10, 2011 | Texas Instruments TI-84 Plus Calculator

1 Answer

I get ERR:DOMAIN every time I enter an inverse trig function


Is your Ti83 plus in degree mode. You can change to radians by pressing the MODE key, and sliding down 2 more positions, and press the ENTER key. Because you got this error your principle value for x and y should be examined. Generally you really should be in radian mode when working with arcsin (aka. sin^-1), and arccos. You probably weren't using arctan because, you would have never gotten this error message due to the fact it goes on forever. And this way your answers for y= arcsin(x), or arccos(x) will be on the x axis, and domains at 0, pi/2, and pi.

You can work in degree mode but, if the number you place in the brackets of your arc sin or arc cos function is larger than 1 or smaller than -1 you will get a ERR:DOMAIN. Using the arctan or (aka. inverse tan) function in the degree mode can be used for computing endless waves, or as an angles that are usually in brackets of cosine or sine. Example: cos(arctan(Beta). This functions that y to never be greater than 1 or, less than 0. Example: sin(arctan(angle). This functions that y to never be less than -1 or, greater than 1.

I hope this answers your question to why you got this error and, helps you to decide on what the correct mode setting should be.

Dec 17, 2010 | Texas Instruments TI-83 Plus Calculator

1 Answer

Casio fx-7400G PLUS cubic solver?


Hi,
First let us repair the terminology.

  1. You can evaluate any expression (find the value of any expression for a particular value of its variable).Store a value in the variable, say X. Key in the expression and press [EXE].
  2. You can consider your expression(should not contain a relational operator such as =, greater than, less than, greater than or equal to, less than or equal to) to be a function Y1(x) = expression and graph it, or generate a table for it. You will have several values of the function calculated at various points.
  3. You can set your expression equal to 0 and find the particular value(s) of the variable (the unknown) that make the equality TRUE. That is called solving an equation.
I am not sure that it has a solver (solving an equation or an inequation) but you can always draw your expression as a function and explore the graph (SKTCH) to locate the roots (or zeros) of the functions (the values of the variable where the function equals zero.) That is called solving graphically.

Hope it helps.
Thank you for using FixYa and for rating this solution.

Nov 05, 2009 | Casio FX-7400G Plus Calculator

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

Related Topics:

88 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2992 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

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

Answer questions

Manuals & User Guides

Loading...