Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel
What is the formula for dividing a number by 4 in excel
|
#2
|
|||
|
|||
You already got at least 2 answers to your previous posts
Regards, Peo Sjoblom "Blessingspoint" wrote: What is the formula for dividing a number by 4 in excel |
#3
|
|||
|
|||
Sorry about that posted 3 times.. I have tried to use it in this way with out
any luck what am I doing wrong? =a1/4*(G19) "Peo Sjoblom" wrote: You already got at least 2 answers to your previous posts Regards, Peo Sjoblom "Blessingspoint" wrote: What is the formula for dividing a number by 4 in excel |
#4
|
|||
|
|||
Your formula should work as written. What problem are you
encountering? What is in cell A1 and cell G19? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Blessingspoint" wrote in message ... Sorry about that posted 3 times.. I have tried to use it in this way with out any luck what am I doing wrong? =a1/4*(G19) "Peo Sjoblom" wrote: You already got at least 2 answers to your previous posts Regards, Peo Sjoblom "Blessingspoint" wrote: What is the formula for dividing a number by 4 in excel |
#5
|
|||
|
|||
Hello;
Your formula is not taking the order of operations into account. Try this: =(a1/4)*g19 The way you wrote it [=a1/4*(G19)], g19 was being mulitiplied by 4 and a1 was being divided by the result. You might want to look at this topic in Excel Help: About calculation operators "Blessingspoint" wrote: What is the formula for dividing a number by 4 in excel |
#6
|
|||
|
|||
The way you wrote it [=a1/4*(G19)], g19 was being mulitiplied by 4 and a1
was being divided by the result. You might want to look at this topic in Excel Help: About calculation operators Not true. A1 is divided by 4, then the result multiplied by G19. WRT precedence, as it says in Help, multiplication and division have the same priority and "if a formula contains both a multiplication and division operator — Excel evaluates the operators from left to right". He wrote =A1/4*(G19). That is the same as =A1/4*G19, which evaluates as I described above. If that's what's wanted, no parentheses are required. Parentheses are needed only if you want to do what you have described, but the the formula for that would be =A1/(4*G19), with the 4 inside the parentheses. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) |