Division

  • Thread starter Thread starter David
  • Start date Start date
D

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 said:
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
Click to expand...

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
 
Back
Top