| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difficult Formula help
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??????? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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??????? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Difficult Formula help
"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??????? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Difficult Formula help
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 --------------- Jacob Skaria "Kez23man" wrote: 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??????? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Difficult Formula help
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??????? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Difficult Formula help
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??????? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Difficult Formula help
"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??????? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difficult formula | Excel Worksheet Functions | |||
| Difficult Formula | Excel Worksheet Functions | |||
| Difficult Formula | Excel Worksheet Functions | |||
| Difficult Formula | Excel Worksheet Functions | |||
| Difficult look up formula | Excel Worksheet Functions | |||
Linear Mode
