Formulas

  • Thread starter Thread starter Patsy
  • Start date Start date
P

Patsy

Hi I am a student and I am working on an excel problem
for spredsheet class and I am having trouble coming up
with formulas to match 4 of my problems. Can anyone help??
Here are how the problems normally would look in a
textbook.

3,516,075 / [(232,500 + 298,570) /2]= 13.24

291,015 + 36,000 / [(2,915,310 + 2,554,575) /2]=.0119

291,015 -0 / [(2,915,310 + 2,554,575)]= .0164

Thanks in advance for anyone who can help!
 
Hi Patsy!

Replace your square brackets with round ones.
Don't put the commas in the numbers

Example:
=3516075/((232500 + 298570)/2)
Returns 13.2414747585064

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Patsy
The formula I used to obtian the answer to the first problem is

(A1+B1)/((C1+D1)/E1) place this formula in the F1 cell. then enter the data in the cells A thru E. If a value is negative insert data with a negative sign. If there is no data for a plus or minus cell then enter zero. If there is no data for a multiplication or division cell enter one
 
Back
Top