I want to create a function or formula

  • Thread starter Thread starter John Weller
  • Start date Start date
J

John Weller

Could somebody please help me simplify my life? I am using Office Excel 2003
I need to create a function in Excel where I have lenth in inches in one
column, multiplied by width in inches in another column, divided by 144 to
get total square feet.
 
Thanks for asking that question David. This is something I might be wrong at
and I am sure you can correct me. I just wanted to make sure that the
formula first multiplies A2 and B2 and then divides the result by 144.

In your formula, is it possible that the formula multiplies A2 by (B2
divided by 144)? Or is it like what we write first happens first?
 
What is the difference between (A2*B2)/144 and A2*(B2/144), Gaurav?

As in many cases in this newsgroup, this is, of course, not an Excel
question, but a question of mathematics.

[But if you want to demonstrate it with Excel, you can put some example
numbers in your spreadsheet and try the following formulae:
=(A2*B2)/144
=A2*(B2/144)
=A2*B2/144

If you want to go a stage further, you can put =A2*B2 in cell D2, put
=B2/144 in E2, and then try =D2/144 and =A2*E2.]
 
I think I was just confused. Thanks though.

David Biddulph said:
What is the difference between (A2*B2)/144 and A2*(B2/144), Gaurav?

As in many cases in this newsgroup, this is, of course, not an Excel
question, but a question of mathematics.

[But if you want to demonstrate it with Excel, you can put some example
numbers in your spreadsheet and try the following formulae:
=(A2*B2)/144
=A2*(B2/144)
=A2*B2/144

If you want to go a stage further, you can put =A2*B2 in cell D2, put
=B2/144 in E2, and then try =D2/144 and =A2*E2.]
--
David Biddulph

Gaurav said:
Thanks for asking that question David. This is something I might be wrong
at and I am sure you can correct me. I just wanted to make sure that the
formula first multiplies A2 and B2 and then divides the result by 144.

In your formula, is it possible that the formula multiplies A2 by (B2
divided by 144)? Or is it like what we write first happens first?
Click to expand...
Click to expand...
 
Back
Top