Formula solution????

  • Thread starter Thread starter Steve S
  • Start date Start date
S

Steve S

I'm new to excel and have a problem that I need solved. Can someon
help? This is what I was givin.

(L1*L2-L3/L4+7L5^2)

L1=5, L2=2, L3=6, L4=3, L5=3

DECIMAL POINT AT 0.


I came out with an answer of 8. Not really sure if I did it right o
not?

Thank You to anyone that replies
 
(L1*L2-L3/L4+7L5^2) has an error. Probably should be
(L1*L2-L3/L4+7*L5^2). I was curious what would happen
if it was typed in as you wrote it and excel corrected as
(L1*L2-L3/L4+L75^2), which assuming L75 is blank,
you get an answer of 8.
 
The original posted formula

=(L1*L2-L3/L4+7L5^2)

could probably be written (as KCC suggested) as

=(L1*L2-L3/L4+7*L5^2)


and plugging in the values of L1 up to L5, I got an answer of 71.

Is this the answer that you were expecting?
 
Besides the obvious mistake (typo?) of
+7L5
You should post back and put your formula into words, as to what you
*exactly* wish to do with the values you have.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


I'm new to excel and have a problem that I need solved. Can someone
help? This is what I was givin.

(L1*L2-L3/L4+7L5^2)

L1=5, L2=2, L3=6, L4=3, L5=3

DECIMAL POINT AT 0.


I came out with an answer of 8. Not really sure if I did it right or
not?

Thank You to anyone that replies.
 
Back
Top