Division

[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

[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" <[email protected]> wrote in message
news:[email protected]...
>
>
> 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
>

[SteveW]

On Wed, 26 Jul 2006 10:26:56 +0100, David <[email protected]> wrote:

> Ah. Do I multiply P by 1.3333?
>

why complicate things just use /

--
Steve (3)

[Franz Verga]

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

[David]

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[SteveW]

??

On Wed, 26 Jul 2006 10:43:44 +0100, David <[email protected]> wrote:

> Ah.Using Product. Thanks.
>



--
Steve (3)