I want to show cell B43 as 17.5% of cell B42, I'm new to formulas.

=B42*17.5%

or:

=B42*0.175
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"eddiethemini" wrote in message
...
I want to show cell B43 as 17.5% of cell B42, I'm new to formulas.

Thank you, I used the second one but it left a % sign, I forgot you could do
it the easier way! its a lot of years since I did a spreadsheet course.

"Sandy Mann" wrote:


=B42*17.5%

or:

=B42*0.175
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"eddiethemini" wrote in message
...
I want to show cell B43 as 17.5% of cell B42, I'm new to formulas.

You're very welcome. Thanks for the feedback

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"eddiethemini" wrote in message
...
Thank you, I used the second one but it left a % sign, I forgot you could
do
it the easier way! its a lot of years since I did a spreadsheet course.

"Sandy Mann" wrote:


=B42*17.5%

or:

=B42*0.175
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"eddiethemini" wrote in message
...
I want to show cell B43 as 17.5% of cell B42, I'm new to formulas.