calculations; multiplying two columns

[bb]

i added three custom colums. i wanted to be able to multiply the vaules in
two colums and put the answer in the third column. is this possible in
project?

 

[Rod Gill]

Yes, use a formula in a custom field. Search project help for custom fields
and formula. If the two fields are Number1 and Number2 and you want the
result in Number3 the formula is:
=[Number1]*[Number2]

Formulae can only be added to custom fields.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[bb]

thanks Rod!

i'll be, i forgot the brackets. actually, i didn't realize to use them.
thanks!

Yes, use a formula in a custom field. Search project help for custom fields
and formula. If the two fields are Number1 and Number2 and you want the
result in Number3 the formula is:
=[Number1]*[Number2]

Formulae can only be added to custom fields.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

i added three custom colums. i wanted to be able to multiply the vaules in
two colums and put the answer in the third column. is this possible in
project?

 

[Mike Glen]

Hi bb,

Welcome to this Microsoft Project newsgroup

You might also like to have a look at my series on Microsoft Project in the
TechTrax ezine, particularly #14 on customizing fields, at this site:
http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the article before leaving the site,
Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

thanks Rod!

i'll be, i forgot the brackets. actually, i didn't realize to use
them. thanks!

Yes, use a formula in a custom field. Search project help for custom
fields and formula. If the two fields are Number1 and Number2 and
you want the result in Number3 the formula is:
=[Number1]*[Number2]

Formulae can only be added to custom fields.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit:
http://www.projectvbabook.com

i added three custom colums. i wanted to be able to multiply the
vaules in two colums and put the answer in the third column. is
this possible in project?

 

[bb]

Thanks Mike. I'll cruise on over and take a look...

Cheers

Hi bb,

Welcome to this Microsoft Project newsgroup

You might also like to have a look at my series on Microsoft Project in the
TechTrax ezine, particularly #14 on customizing fields, at this site:
http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the article before leaving the site,
Thanks.)

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

thanks Rod!

i'll be, i forgot the brackets. actually, i didn't realize to use
them. thanks!

Yes, use a formula in a custom field. Search project help for custom
fields and formula. If the two fields are Number1 and Number2 and
you want the result in Number3 the formula is:
=[Number1]*[Number2]

Formulae can only be added to custom fields.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit:
http://www.projectvbabook.com


i added three custom colums. i wanted to be able to multiply the
vaules in two colums and put the answer in the third column. is
this possible in project?

 

[Mike Glen]

You're welcome, bb

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

Thanks Mike. I'll cruise on over and take a look...

Cheers

Hi bb,

Welcome to this Microsoft Project newsgroup

You might also like to have a look at my series on Microsoft Project
in the TechTrax ezine, particularly #14 on customizing fields, at
this site: http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the article before leaving the site,
Thanks.)

FAQs, companion products and other useful Project information can be
seen at this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP

thanks Rod!

i'll be, i forgot the brackets. actually, i didn't realize to use
them. thanks!

:

Yes, use a formula in a custom field. Search project help for
custom fields and formula. If the two fields are Number1 and
Number2 and you want the result in Number3 the formula is:
=[Number1]*[Number2]

Formulae can only be added to custom fields.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit:
http://www.projectvbabook.com


i added three custom colums. i wanted to be able to multiply the
vaules in two colums and put the answer in the third column. is
this possible in project?