PDA

View Full Version : Microsoft Excel


jEnkinsX
Apr 8th, 2005, 11:53 PM
how do u multiply?

i want the totals of (b1 to b27) * .15

i did
=MULT(0.15*(B1:B26))
i doesnt work

devious9191
Apr 8th, 2005, 11:55 PM
=sum(b1:b7)*.15 ?

jEnkinsX
Apr 9th, 2005, 12:02 AM
thanks that worked!

last thing, is there a way to see all the formuals i can use in excel?

ephemera
Apr 9th, 2005, 12:17 AM
just check excel help. Its pretty extensive, otherwise grab a cheap excel book.

devious9191
Apr 9th, 2005, 12:30 AM
Just google man. I can guaranty that 'excel column total multiply' would have given you the same answer I did... anything you want to do in excel, just stick er in.

joo
Apr 10th, 2005, 11:16 AM
last thing, is there a way to see all the formuals i can use in excel?

On the menu:

Insert --> Function

divx
Apr 10th, 2005, 02:06 PM
extensive help can be found here
http://msdn.microsoft.com/