I don't know how to set up the cell where it will do division....I was guessing that it was the MOD function...but didn't work out...please help!

thanks!

 

=a1/5

Regular division?

 

^^ he's right if thats all you need to do

 

That's It!! It Worked!

Thanks So Much!

 

People really should pay attention.

 

wait...one more question...how do I set it up so it automatically calulates down the cell...
this is kind of hard to explain...this is what i am trying to do...

Gallons Milage MPG
XX.XXX XXX.X =aX/bX

How do I set it up so I don't have to type in "a=" every time on the MPG cell so it does it automatically after I put in Gallons and Milage...

hope this makes sense

 

Click the corner and drag...

 

It should calculate automatically whenever you change a value in the field. If you want to enter multiple gallons and millage in a columnular format you:

1. highlight the cell with the equation
2. click and drag the box in the lower right corner of the cell down to the last cell where you want the equation.

Then when you enter values in each cell for gallons and Milage the equation will calculate for you.

 

Fine if you want to simplify the process

 

Sounds like someone needs to take an Excel class.

 

Don't confuse the poor guy anymore....he just asked us how to make a division formula....

 

I hope Jeff is a damn good pianist.

 

sounds like someone needs to click on the friggin Excel help button.

 

I know how to use the Transpose function! I learned last week!!!

 

Lol, I know what you mean. I consider myself an advance excel user (outside of Macros) and I just leanred how to use transpose a couple weeks ago. I was pretty excited.

 

Suggest you get on to the next level & learn VBA and if you put it to use you'd get serious respect from co-workers and more $$

 

Rows are now Columns, America!

... I'm sure this could make the front page of the local paper, if the ethanol plant wasn't so controversial.

 

Excel for Dummies ownz j000