symbol functions

S

SeanW

I have this in my calculation of an excel sheet and I don't know what $
symbol does in it. =SUM(E10/(100-$E$8)*100)

example E8 =27.5
E10 = 1058
but the sum is $1,459.31
How is this? I tried everyway I knew.
Thanks
Sean
 
D

Dave Peterson

If you copy that formula to a different cell, then the $e$8 won't change.

This is used when there's a constant in $e$8 that should be used in all those
formulas.

But I would drop the =sum() from your formula:

=(E10/(100-$E$8))*100

And I added parentheses just so that it would be easier for me to understand.
Excel doesn't require them.
 
Top