Refer the below link on usage of arithmetic operators..
http://www.homeandlearn.co.uk/excel2...l2007s4p4.html

If you still find it difficult; explain without using arithmetic operators
what you are looking at. Or otherwise it would be difficult for anyone to
figure what you are looking at...

If this post helps click Yes
---------------
Jacob Skaria


"Kez23man" wrote:

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