Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula upon Formula......ARRRRGH!!!!!!!
Ok I need to DISPLAY a 2% of a cell that contains a total
The simple math is 6706/2% = 134.12 The problem MIGHT be the fact that the 6706 is a formula itself to figure out that # {cell D26} Ok so the formula Im using for the "grand total" cell D26 is: =SUM(C26+C13) What I need in cell e12 is: The grand total of cell D26 + Divided by 2% = I tried =sum(D26/.02) I tried =sum((e26)/.02) {with e26 = D26} I tried =sum(abs(e26)/.02)) I tried =(abs(e26)/.02)) What I keep getting is the answer 335,300.........???!!! HELP MATH WIZARDS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula upon Formula......ARRRRGH!!!!!!!
You're getting the right answer - 6706 divided by 2% (or 0.02) *IS*
335,300. To get 134.12, you need to MULTIPLY by 2%: =6706 * 2% In article , 23Hitamn wrote: Ok I need to DISPLAY a 2% of a cell that contains a total The simple math is 6706/2% = 134.12 The problem MIGHT be the fact that the 6706 is a formula itself to figure out that # {cell D26} Ok so the formula Im using for the "grand total" cell D26 is: =SUM(C26+C13) What I need in cell e12 is: The grand total of cell D26 + Divided by 2% = I tried =sum(D26/.02) I tried =sum((e26)/.02) {with e26 = D26} I tried =sum(abs(e26)/.02)) I tried =(abs(e26)/.02)) What I keep getting is the answer 335,300.........???!!! HELP MATH WIZARDS |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula upon Formula......ARRRRGH!!!!!!!
Ok That works to get the number I need to display in that cell.
However,,,,, The total amount cell that I need now does not let me adjust the =sum formula that I want. So I want this last cell to take the contens of the cell we fixed, less the big general number and display the difference (keep in mind that the big geneal number is a formula itself to get the number. When I try =sum(c26-c11-c23) I get a circular reference .................. When I try =sum(C26-c11) I get a circular reference...... One more try? "JE McGimpsey" wrote: You're getting the right answer - 6706 divided by 2% (or 0.02) *IS* 335,300. To get 134.12, you need to MULTIPLY by 2%: =6706 * 2% In article , 23Hitamn wrote: Ok I need to DISPLAY a 2% of a cell that contains a total The simple math is 6706/2% = 134.12 The problem MIGHT be the fact that the 6706 is a formula itself to figure out that # {cell D26} Ok so the formula Im using for the "grand total" cell D26 is: =SUM(C26+C13) What I need in cell e12 is: The grand total of cell D26 + Divided by 2% = I tried =sum(D26/.02) I tried =sum((e26)/.02) {with e26 = D26} I tried =sum(abs(e26)/.02)) I tried =(abs(e26)/.02)) What I keep getting is the answer 335,300.........???!!! HELP MATH WIZARDS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
formula is displayed as literal text instead of formula result | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |