Difficult Formula help

[Kez23man]

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

 

[Kez23man]

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)

 

[JoeU2004]

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

 

[Jacob Skaria]

What do you intend to do when you write

E8(E10)

Is it E8*whatever within brackets or what...Change that to the +-/* as your
requirement...

If this post helps click Yes

 

[Kez23man]

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

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

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)

 

[Jacob Skaria]

Refer the below link on usage of arithmetic operators..
http://www.homeandlearn.co.uk/excel2007/excel2007s4p4.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

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

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

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)


:

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

 

[JoeU2004]

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

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

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

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)


:

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