Question about Microsoft Excel for PC

1 Answer

I need need answer for..

Below mention is my equation.

(437/10000)X = 0.287

I need to find the value 'X'

how to derive. Please help me

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 8 Answers

==>(437/10000)X=0.287
==>X=(.287)/(437/10000)
==>X=6.5675

Posted on Jan 04, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

What is the "&" symbol for in excel 2010?


The "&" symbol is commonly known as "ampersand" and it is a calculation operator. Ampersand can be used in Excel 2010 to join text items from different cells. It functions much similar as "CONCATENATE" function. The output value you will get by using ampersand function will be the same as the one you will get by using CONCATENATE function. For example, =A1 & B1 returns the same value as=CONCATENATE(A1, B1)

To know more about the CONCATENATE/ ampersand function, you can refer to the following webpages:
http://office.microsoft.com/en-in/excel-help/concatenate-function-HP010342288.aspx

(Important: Below mentioned link is of a third-party website. We recommend you to update your security software thoroughly before clicking on the link.)
http://excelsemipro.com/2010/08/concatenate-function-or-ampersand-operator-in-excel/

(Important: Below mentioned link applies to Excel 2007. Still, you can refer it to understand more about ampersand function.)
http://office.microsoft.com/en-in/excel-help/combine-the-contents-of-multiple-cells-HA010248390.aspx?CTT=1

GuruAid.com

Jul 30, 2014 | Microsoft Excel 2010

1 Answer

Average Handling Time for Emails


You only need one formula for this.
Total handling time divided by the total number of emails answered.

May 13, 2013 | Microsoft Excel for PC

1 Answer

Using an excel sheet, assume that sum of some cells is 100.77 and i want to use this sum in other cells but 100 in a cell and 0.77 in another cell, so what is the equation or what can i do to do it ??


You could use the round function to split the value around the decimal point (assuming that is what you want to do).

e.g. in one cell the value is Rounddown(ref cell)
in other cell value is refcell - Rounddown(ref cell)

Might want to check help file on "rounding" to confirm exact function name

Nov 24, 2009 | Microsoft Excel for PC

1 Answer

1. calculation for excel spreadsheet macro for calculating the a right angle triangles hypotinuse and opposite side, angle given


Hello this is Baris,
First off all when you say hypotinuse I think it is a 90 Degree triangle. Total of the angles off a triangle is 180 degree. So it is a simple algebra question.

Hypotinuse is 90
Right angle is R
Left angle is L
Total is 180

Equation is 90+ R +L = 180

We are looking for R, so lets arrange our equation.

R= 180 - 90 - L
R= 90 - L

This is our formula for excel

Lets put it in the excel
Type in A1 "hypotinuse "
Type in A2 "Left Angle"
Type in A3 "Right Angle"

Type in B1 90
Type in B2 "whatever the value given for the left angle"
Type in B3 =90-B2

As soon as you change the value in the cell B2, B3 will change by itself. Hope this helps :)


Sep 27, 2009 | Microsoft Excel for PC

4 Answers

Using excel to solve problem by trial and error method


In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein refer d as A1. Then use goal seek function on Tools Menu. First "Set cell" as B1, "To value" as 0.124 and "By Changing Cell" as A1. Excel will do the Trial & Error and will give you the answer in Cell A1.

Nilesh

Mar 31, 2009 | Microsoft EXCEL 2004 for Mac

2 Answers

FORMULA TO COMPLETE A COUNT TO A PERCENTAGE


Apply the following:
COUNT(A3:A74)/COUNTIF(A3:A74,"1")*100 in order to obtain the percentage.

Nov 26, 2008 | Microsoft Office 2003 Basic Edition...

1 Answer

Excel Addition


you may add typed-in values (numbers only) or numbers found in cells.
always start your equation with = then separate values with +

Nov 22, 2008 | Microsoft Business & Productivity Software

1 Answer

Excel help


Maybe this is what you need:
=IF(A1="toilet",(B1*2),(IF(A1="bread",(B1*3),(IF(A1="star",(B1*4))))))
this is called "nested".
You can put nested if function maximum 7. (for more than 7, we should make another "trick")
if you put toilet in A1 then come the value B1*2
if you put bread in A1 then come the value B1*3
if you put star in A1 then come the value B1*4
Note: SUM(F16*0.3) is wrong. should be only (F16*0.3) or if you want to do sum --> SUM(F16:F20)

Apr 01, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Ms excel function


I'm not entirely sure how you want to use this, but it is fairly easy to automatically assign a value to a cell based on the value in another.

Let's assume that you enter your score (A, B, C or D) in cell A1. If you put the following equation in cell A2 it will then display the corresponding score:

=IF(A1="A",3,IF(A1="B",2,IF(A1="C",1,IF(A1="D",0))))

You can go on adding as many further 'IF' statements as you like.

You can elaborate on this a bit by changing it to the following:

=IF(A1="A",3,IF(A1="B",2,IF(A1="C",1,IF(A1="D",0,"Not Scored"))))

By adding the final 'Not Scored' entry it prevents cell A2 from displaying 'FALSE' as an output.

Matt

Feb 26, 2008 | Microsoft Excel for PC

1 Answer

Numerical methods


Is this the formula you are looking for:

=sum(a+bx+cx*2)

If this helps, please rate me. Thanks, Patty

Oct 12, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

54 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...