EXCEL FORMAT ?

  Furkin 08:49 08 May 2009
Locked

I'm making a table of my car fuel consumption. I need to convert litres to gallons after each fill-up. The math is fine, & I get the format "=(?/?)" o.k.
I want to use the same format (or similar) in every cell in a column.
Say if I have column A for litres & column B for Gallons - how do I set all of column B to convert the previous cells number, automatically ?
I can do the format to convert A1 to B1, A2 to B2 etc, but only one at a time. I've been playing with the 'stretch' handle hoping to make all of column B into a formatted one.
The problem is, that to convert A1 to B1, one has to actually choose A1 to start with. If I try to use an automated format for A2 to B2, it 'assumes' that I still want to convert A1 - cos that's the figure I first used !

I know i'm making a pigs ear of explaining this, but I know you guys will understand it,,,, just as much as I know you'll have the answer.

thanks for reading this,,,,,,,

  VoG II 09:16 08 May 2009

In B1 enter the formula


=IF(A1="","",A1/4.54)

Click in B1 then hover the cursor over the bottom right of the cell until the cursor turns into a + then hold down the left mouse button and drag down as far as you want.

Now if you look in B2 you should see the formula is

=IF(A2="","",A2/4.54)

and so on down the column.

  Fermat's Theorem 15:51 09 May 2009

in having a look at the MPG spreadsheet I devised some time ago. click here

:-)

  Furkin 00:31 10 May 2009

VOG:
Cheers again mate - spot on.

F.THEOREM:
Yep - I like it.
I hadn't added the cost values this time, as I used to insert 'em manually.
I'll look up how to add the buttons, to jazz mine up a bit. Thanks

F

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?