View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kez23man Kez23man is offline
external usenet poster
 
Posts: 3
Default Difficult Formula help

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