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

 

[SteveW]

Ah. Do I multiply P by 1.3333?

why complicate things just use /

 

[Franz Verga]

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

 

[SteveW]

??

Ah.Using Product. Thanks.