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