Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |