LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy formula down a column and have cell references change within formula brad New Users to Excel 5 May 13th 07 04:38 PM
Build excel formula using field values as text in the formula val kilbane Excel Worksheet Functions 2 April 18th 07 01:52 PM
Excel 2002 formula displayed not value formula option not checked Dean Excel Worksheet Functions 1 February 28th 06 02:31 PM
formula is displayed as literal text instead of formula result carlossaltz Excel Discussion (Misc queries) 2 July 1st 05 09:26 PM
Cell doesn't show formula result - it shows formula (CTRL + ' doe. o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"