Going crazy

[Lorrie]

I am having trouble with a formula. I need to subtract
one cell from another and then a third cells needs to be
divided by the results of the first computation.

If I use =SUM($A$23-S51)/R51 the results are 1000.00%
I'm definately doing something wrong. Is Sum the correct
function. So R51 needs to be divided by the results of
a23-s51.

Can you tell me where is the best place to learn about
functions and how to use them.

Thank you for your help!

 

[Don Guillett]

how about
=(a23-s51)/r51
and then look at your formatting

 

[Guest]

Thanks for trying but it needs to go the other way....I
don't need to divide R51 by the results...I need to
divide the results by R51.

 

[Dave R.]

Don's formula does what you want, subtracts s51 from a23 then divides that
by r51.

if you're not getting the result you want, you should look at the values of
those cells.

 

[Haldun Alay]

Hi,

Can you post what values "A23, S51, R51" cells have to get that result.

--
Regards

Haldun Alay

To e-mail me, please remove AT and DOT from my e-mail address.



"Lorrie" <[email protected]>, iletide sunu yazdi I am having trouble with a formula. I need to subtract
one cell from another and then a third cells needs to be
divided by the results of the first computation.

If I use =SUM($A$23-S51)/R51 the results are 1000.00%
I'm definately doing something wrong. Is Sum the correct
function. So R51 needs to be divided by the results of
a23-s51.

Can you tell me where is the best place to learn about
functions and how to use them.

Thank you for your help!

 

[Gord Dibben]

Lorrie

=R51/($A$23-S51) is the literal translation of your question.

You don't need the SUM when adding/subtracting two cells.

Excel's Help files have examples for all Functions.

Also check out Help>Index> "operator" "about calculation operators"

Do not enter the quotes when typing).

I notice also that you have a mix of absolute($A$23) and relative(S51)
references. Is this deliberate?

If not, see Help also on "reference" "the difference between rlative and
absolute references"

Gord Dibben XL2002