"Kez23man" wrote:
the formula returns a #REF, I have looked at formula help but
still no answers, hope this helps.

Well, it tells me that what you posted is not exactly the formula that you
have in the worksheet. It would help if you copy-and-pasted the formula
from the Formula Bar (next to "fx" under the toolbar in Excel 2003) into
your posting here.

When I enter the formula from your earlier posting, Excel offered the
following corrections (which I simplified):

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

This is the second alternative that I offered in my previous posting.
Please make sure this is what you intended.

In any case, the #REF has nothing to do with the syntax errors in your
posting.

Look at the #REF help page and follow the instructions there.

To see the help page, if you are using Excel 2003, press F1, enter "#REF"
without quotes in the Search For field and press Enter, then click "Correct
a #REF! error".

Does that give you the answer that you need?


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

"Kez23man" wrote in message
...
Joe,
the formula returns a #REF, I have looked at formula help but still no
answers, hope this helps.



"JoeU2004" wrote:

"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???????