Pete Zahut wrote:
the_constructor wrote:
"Pete Zahut" dont@bother wrote in message
...
the_constructor wrote:
Got a little problem trying to sort out a formula for a spreadsheet.
Yes, some of you may think that I should use a different group, but
all the computer groups are not as helpful as this group.

Can anyone help ?

C23 = 34

C27 = 0.6530

C31 = Total

Now the formula that I need is like this:

If (C23670) Then Let C31 = (C23*C27)

I am trying to write a spreadsheet to work out the cost of my gas
bill. New meter installed with reading of zero a couple of weeks
ago. upto 670 KWh gas is charged a 0.06530p per KWh
after that it is charged at another price. I got the after bit
worked out but beggered if I can sort the first bit.

Anyone wish to hazzard a guess at the formula ?

Kindest regards,

Jim
I'll go one further and say that I have no idea whatsoever on how to
use spreadsheets. I have Microsoft Excel as part of the Office suite
but never used it - opened it once, scratched me 'ed, and shut it
down again ) So, if anyone would be considerate enough to write
out a complete step-by-step idiots guide on how to do this from
scratch, I would be eternally grateful.

Cheers,

Pete

Hi Pete,

I just did a google and came up with this for you:

http://www.rgu.ac.uk/files/ACF2EE7.pdf

and

http://www.amazon.co.uk/s/ref=nb_ss_...xcel&x=17&y=15

Kindest regards,

Jim

Thanks Jim. I'll give the pdf a good coat of looking at but I don't know as
I'm interested enough to buy a book - after all, I've managed 51 years
without knowing how to use spreadsheets. It just seemed that working out gas
and electric costs may be OK but I can't think of anything else I'd need to
use a spreadsheet for.

A DIY uses I find them particularly handy for is costing jobs. Just
stick in a column of descriptions, another of quantities, another of
prices. Then let it work out the total cost. Makes it very easy to tit
about with costs and prices etc.

Example:


A B C D
1 Description Unit Price Qty Total
2
3 25kg Bag sand 2.50 3 =B3*C3
4 Cement 3.90 1 =B4*C4
5
6
7
8
9 Total Cost =sum(D37)





--
Cheers,

John.

/================================================== ===============\
| Internode Ltd - http://www.internode.co.uk |
|-----------------------------------------------------------------|
| John Rumm - john(at)internode(dot)co(dot)uk |
\================================================= ================/