"Kez23man" wrote:
I need help I can't get this formula to work and am unsure why

So am I, since you do not even tell us in what way the formula does not
work.


I am trying to work out the fuel rise and fall formula for a tendered
rate.
[....]
=B6( (E8(B10)/B12) + E14*((B16)/B18)) + (E20(B22)/B24)+E26 )

I have no knowledge of the mathematics. But I wonder if this is what you
mean to write:

=B6 * ( E8*B10/B12 + E14*B16/B18 + E20*B22/B24 + E26 )

I eliminated unneeded parentheses to make the formula more readable, and
most importantly, I changed occurrences like E8(B10) to E8*B10, if that's
what you mean.

But your original use of parentheses is erroneous; so your intent is
unclear. Alternatively:

=B6 * ( E8*B10/B12 + E14*B16/B18 ) + E20*B22/B24 +E26


------ original message -----

"Kez23man" wrote in message
...
Some more information

I am trying to work out the fuel rise and fall formula for a tendered
rate.
I know that my cell references are correct, here are the numbers
corresponding to the cell references.

B6= $1.24
E8=$7.86
B10=120.5
B12=107.5
E14=$18.35
B16=155.1
B18=138.3
E20=$18.35
B22=205.1
B24=199.9
E26=$7.86

AND THE FORMULA SHOULD ACTUALLY READ AS FOLLOWS

=B6((E8(B10)/B12)+E14*((B16)/B18))+(E20(B22)/B24)+E26)


"Kez23man" wrote:

I need help I can't get this formula to work and am unsure why.........

=B6((E8*(B10)/B12)+E14*((B16)/B18))+(E20*(B22)/B24)+E26)

can anyone help???????