O T: Spreadsheet help
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
|