Percentage calculation

**Roz** · 01-06-2006, 01:09 PM

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.

**BenjieLop** · 01-06-2006, 01:19 PM

Originally Posted by Roz

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.

Stephen · 01-06-2006, 01:20 PM

"Roz" <Roz.2183em_1136567400.8517@excelforum-nospam.com> wrote in message
news:Roz.2183em_1136567400.8517@excelforum-nospam.com...
>
> 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

pinmaster · 01-06-2006, 01:20 PM

=H17*10%

Regards
JG

bpeltzer · 01-06-2006, 01:25 PM

=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
>
>