Percentage calculation
 

In G18, I want this cell to calculate 10% of the number in H17. How can
I make a formula for this? I try to simply put in =H17(0.1), but it
gives me a
!REF error. Thanks.


--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=498761

Percentage calculation
 

"Roz" wrote in message
...

In G18, I want this cell to calculate 10% of the number in H17. How can
I make a formula for this? I try to simply put in =H17(0.1), but it
gives me a
!REF error. Thanks.

=H17*0.1
or
=H17/10

Percentage calculation
 

Roz Wrote:
In G18, I want this cell to calculate 10% of the number in H17. How can
I make a formula for this? I try to simply put in =H17(0.1), but it
gives me a
!REF error. Thanks.

*=0.1*H17* is your formula.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=498761

Percentage calculation
 

=H17*10%

Regards
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=498761

Percentage calculation
 

=h17*.1

"Roz" wrote:


In G18, I want this cell to calculate 10% of the number in H17. How can
I make a formula for this? I try to simply put in =H17(0.1), but it
gives me a
!REF error. Thanks.


--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=498761

Percentage calculation
 

Thanks to all you geniuses!


--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=498761