Division

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 26 Jul 2006 10:12 GMT

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

Reply to this Message

David - 26 Jul 2006 10:26 GMT

Ah. Do I multiply P by 1.3333?

Signature

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

> Basic one this...but Excel makes it reasonably clear how to add and
> multiply, but not how to divide.
[quoted text clipped - 4 lines]
> Thanks
> David

Reply to this Message

SteveW - 26 Jul 2006 10:29 GMT

> Ah. Do I multiply P by 1.3333?

why complicate things just use /

Signature

Steve (3)

Reply to this Message

Franz Verga - 26 Jul 2006 10:30 GMT

> Basic one this...but Excel makes it reasonably clear how to add and
> multiply, but not how to divide.
[quoted text clipped - 4 lines]
> 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...

Signature

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Reply to this Message

David - 26 Jul 2006 10:43 GMT

Ah.Using Product. Thanks.

Signature

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

>> Basic one this...but Excel makes it reasonably clear how to add and
>> multiply, but not how to divide.
[quoted text clipped - 12 lines]
>
> and press Enter. Then you can drag for as many rows you need...

Reply to this Message

SteveW - 26 Jul 2006 11:06 GMT

> Ah.Using Product. Thanks.

Signature

Steve (3)

Reply to this Message