Home |
Search |
Today's Posts |
#1
|
|||
|
|||
multiplication in an Excell Spreadsheet
I am having difficulty in multiplying 285 units by 5.960 p. per unit. Can
anyone help me solve this problem please? |
#2
|
|||
|
|||
With 285 in cell A1 and 5.96 in cell A2, in cell A3 put =A1*A2
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "KiaOra" wrote in message ... I am having difficulty in multiplying 285 units by 5.960 p. per unit. Can anyone help me solve this problem please? |
#3
|
|||
|
|||
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 -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "KiaOra" wrote in message ... I am having difficulty in multiplying 285 units by 5.960 p. per unit. Can anyone help me solve this problem please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lable ranges in Excell | Excel Discussion (Misc queries) | |||
How do I create a daily spending spreadsheet in Excell? | Excel Worksheet Functions | |||
i have microsoft works spreadsheet not excell, can i upgrade to ex | Excel Discussion (Misc queries) | |||
can I print labels using data from an excell spreadsheet | Excel Discussion (Misc queries) | |||
Can I transfer data from and excell spreadsheet to print labels u. | Excel Discussion (Misc queries) |