Below mention is my equation.

(437/10000)X = 0.287

I need to find the value 'X'

how to derive. Please help me

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

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

(

http://excelsemipro.com/2010/08/concatenate-function-or-ampersand-operator-in-excel/

(

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

You only need one formula for this.

Total handling time divided by the total number of emails answered.

Total handling time divided by the total number of emails answered.

May 13, 2013 | Microsoft Excel for PC

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

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

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 :)

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

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

Nilesh

Mar 31, 2009 | Microsoft EXCEL 2004 for Mac

Apply the following:

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

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

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

you may add typed-in values (numbers only) or numbers found in cells.

always start your equation with = then separate values with +

always start your equation with = then separate values with +

Nov 22, 2008 | Microsoft Business & Productivity Software

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)

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

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

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

Is this the formula you are looking for:

=sum(a+bx+cx*2)

If this helps, please rate me. Thanks, Patty

=sum(a+bx+cx*2)

If this helps, please rate me. Thanks, Patty

Oct 12, 2007 | Microsoft Office Standard for PC

Jan 28, 2016 | Microsoft Excel for PC

54 people viewed this question

Usually answered in minutes!

×