[ARCHIVED THREAD] - Quickoffice pro formula help

Posted: 9/17/2012 4:02:59 PM EDT

In h4 I've entered. =mod(e4,g4) all I get is ######

E4 = 429 g4 = 14.26

What am I doing wrong?

Posted: 9/17/2012 4:27:58 PM EDT

[#1]

In Excel 2010, I get 1.2

What's your cell format set to?

Posted: 9/17/2012 4:37:13 PM EDT

[#2]

I changed h4 to number format and get 3.86. It should be 30.08

I'm trying to divide mileage by gas used for mpg.

I'll be the 1st to admit my math skills and spread sheet skils are weak.

Posted: 9/17/2012 4:46:49 PM EDT

[#3]

I'm even more confused than ever.

MPG is Miles/gallons, right?

429/14.26=30.08

=+e4/g4

Am I missing something here?

Posted: 9/17/2012 4:53:17 PM EDT

[#4]

Your column isn't wide enough to display it

Posted: 9/17/2012 5:39:03 PM EDT

[#5]

Quoted:
I'm even more confused than ever.

MPG is Miles/gallons, right?

429/14.26=30.08

=+e4/g4

Am I missing something here?

Yes, miles per gallon.

I used your formula =+ and that worked. thanks!

Posted: 9/17/2012 5:42:13 PM EDT

[#6]

So in 429 miles of all freeway driving at speeds of ~75 mph I got 30.08 mpg in a full sized car, a Toyota Avalon.

[ARCHIVED THREAD] - Quickoffice pro formula help

Warning

Confirm Action

[ARCHIVED THREAD] - Quickoffice pro formula help

[ARCHIVED THREAD] - Quickoffice pro formula help