Two cells put into formula??

[Mikebyrne]

I have two cells "n" and "m" which I want to place into the following formula

1-n/(n+m)

How do I do this to retun the anser in another cell?

[shg]

Formulas only return values to the cells in which they appear.

[Palmetto]

if "n" refers to cell A1
and "m" refers to cell B1
Then in, say C1:

=1-(A1/(A1+B1))

I assume you want the order of operation to be
Add A1+B1, then divide A1 by the result, then 1-result of divison.

Otherwise, your original formula
=1-A1/(A1+B1)

[Mikebyrne]

So its not possible to run the formula??

[Palmetto]

You have to use cell references in formulas.
If you want letters to stand for a cell reference, then name the cell.

[shg]

Then in, say C1:

=1-(A1/(A1+B1))

I assume you want the order of operation to be Add A1+B1, then divide A1 by the result, then 1-result of divison.

Otherwise, your original formula

=1-A1/(A1+B1)

Both formulas give the same result; multiplication and division have higher precedence that addition/subtraction.

[Palmetto]

Doh! I know that. Who can forget Please Excuse My Dear Aunt Sally (PEMDAS)

[Mikebyrne]

Thanks for all the help! Problem solved

[Palmetto]

Please post your solution so that others finding this thread will have an answer. Also, don't forget to mark your thread as solved.