multiplication in an Excell Spreadsheet

K

KiaOra

I am having difficulty in multiplying 285 units by 5.960 p. per unit. Can
anyone help me solve this problem please?
 
S

Sandy Mann

LiaOra,

If the reason is that you have 5.960p in the Per Unit column then the 'p' is
making the whole entry text and you can't do maths on text. If you wish to
keep the entry as it is then with the unit price in B1 try:

=A2*--(LEFT(B2,LEN(B2)-1))

but it would be much more logical if you simply removed the 'p'

HTH

Sandy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Find and replace macro for Special ^p - MS Word 0
Macro to Select text from a point given to a specific word 2
Calculate the median value before a specified list 0
Need Help with Macro Security 1
Level resource allocation error 1
Changing language from UK to US English 0
Ppmh 1

Top