Basic one this...but Excel makes it reasonably clear how to add and
multiply, but not how to divide.
I want the values in column S to be those in column P divided by 0.75. How
do I do this please?
Thanks
David
Basic one this...but Excel makes it reasonably clear how to add and
multiply, but not how to divide.
I want the values in column S to be those in column P divided by 0.75. How
do I do this please?
Thanks
David
Ah. Do I multiply P by 1.3333?
--
David Kitching Msc. Msc.
Managing Director
Natural Deco Ltd.
The Manor
Manor Lane
Loxley
Warwickshire CV35 9JX
UK.
Tel: +44 (0) 1789 470040
Mob: +44 (0) 7799 118518
www.naturaldeco.co.uk
"David" <curvedball@yahoo.com> wrote in message
news:mfCdnfpxeLxurFrZRVnyvA@bt.com...
>
>
> Basic one this...but Excel makes it reasonably clear how to add and
> multiply, but not how to divide.
>
> I want the values in column S to be those in column P divided by 0.75. How
> do I do this please?
>
> Thanks
> David
>
On Wed, 26 Jul 2006 10:26:56 +0100, David <curvedball@yahoo.com> wrote:
> Ah. Do I multiply P by 1.3333?
>
why complicate things just use /
--
Steve (3)
David wrote:
> Basic one this...but Excel makes it reasonably clear how to add and
> multiply, but not how to divide.
>
> I want the values in column S to be those in column P divided by
> 0.75. How do I do this please?
>
> Thanks
> David
Hi David,
Just type in the first free cell in S column, say it is S2, the formula:
=P2/0.75
and press Enter. Then you can drag for as many rows you need...
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
Ah.Using Product. Thanks.
--
David Kitching Msc. Msc.
Managing Director
Natural Deco Ltd.
The Manor
Manor Lane
Loxley
Warwickshire CV35 9JX
UK.
Tel: +44 (0) 1789 470040
Mob: +44 (0) 7799 118518
www.naturaldeco.co.uk
"Franz Verga" <fra68ve@InVento.it> wrote in message
news:e72xwYJsGHA.1288@TK2MSFTNGP02.phx.gbl...
> David wrote:
>> Basic one this...but Excel makes it reasonably clear how to add and
>> multiply, but not how to divide.
>>
>> I want the values in column S to be those in column P divided by
>> 0.75. How do I do this please?
>>
>> Thanks
>> David
>
> Hi David,
>
> Just type in the first free cell in S column, say it is S2, the formula:
>
> =P2/0.75
>
> and press Enter. Then you can drag for as many rows you need...
>
>
> --
> Hope I helped you.
>
> Thanks in advance for your feedback.
>
> Ciao
>
> Franz Verga from Italy
>
??
On Wed, 26 Jul 2006 10:43:44 +0100, David <curvedball@yahoo.com> wrote:
> Ah.Using Product. Thanks.
>
--
Steve (3)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks