multipy 2 values in a cell?

[Majid]

I have a customized column and I would like to multiply
two or three values in the same cell and be able to see
the subtotal in the same cell.
Please advise
Regards,
Majid

 

[JackD]

A custom field can only return the value of the formula. It does not allow
direct input.
To do this you can insert other fields and use the formula to return the
value.

ie: use number1 and number2 for input, number3 to return their product using
the formula [number1]*[number2]

-Jack

 

[Majid]

Hi Jack,
Thank you for your respond.
I have already "Number 1" for value entry and "Number 7"
for the product based on the micro. This micro is summing
the valuesfor the the filterd projects by the date range
and I am absolutely okay with it.
With respect to my problem, is there any way to customize
the customized column "number 1" to allow me to multiply
two numbers? Maybe I should create another column let
say "number 3" and link the product "number 3" to
my "number 7" which has the micro?
Please advisae.
Regards,
Majid

-----Original Message-----
A custom field can only return the value of the formula. It does not allow
direct input.
To do this you can insert other fields and use the formula to return the
value.

ie: use number1 and number2 for input, number3 to return their product using
the formula [number1]*[number2]

-Jack

I have a customized column and I would like to multiply
two or three values in the same cell and be able to see
the subtotal in the same cell.
Please advise
Regards,
Majid

.

 

[Gérard Ducouret]

Hello Majid,
Have you tried this formula in the Number3 field?
[Number1]*[Number7]

Hope this helps,

Gérard Ducouret

Hi Jack,
Thank you for your respond.
I have already "Number 1" for value entry and "Number 7"
for the product based on the micro. This micro is summing
the valuesfor the the filterd projects by the date range
and I am absolutely okay with it.
With respect to my problem, is there any way to customize
the customized column "number 1" to allow me to multiply
two numbers? Maybe I should create another column let
say "number 3" and link the product "number 3" to
my "number 7" which has the micro?
Please advisae.
Regards,
Majid

-----Original Message-----
A custom field can only return the value of the formula. It does not allow
direct input.
To do this you can insert other fields and use the formula to return the
value.

ie: use number1 and number2 for input, number3 to return their product using
the formula [number1]*[number2]

-Jack

I have a customized column and I would like to multiply
two or three values in the same cell and be able to see
the subtotal in the same cell.
Please advise
Regards,
Majid

.

 

[JackD]

A column can NOT be used for both value entry and calculation.
(well, it can but only in the case that the summary task is allowed to not
use a formula - this is not applicable to your situation)
So if you want to enter two values and calculate a third, you need to use
three columns.

-Jack

Hi Jack,
Thank you for your respond.
I have already "Number 1" for value entry and "Number 7"
for the product based on the micro. This micro is summing
the valuesfor the the filterd projects by the date range
and I am absolutely okay with it.
With respect to my problem, is there any way to customize
the customized column "number 1" to allow me to multiply
two numbers? Maybe I should create another column let
say "number 3" and link the product "number 3" to
my "number 7" which has the micro?
Please advisae.
Regards,
Majid

-----Original Message-----
A custom field can only return the value of the formula. It does not allow
direct input.
To do this you can insert other fields and use the formula to return the
value.

ie: use number1 and number2 for input, number3 to return their product using
the formula [number1]*[number2]

-Jack

I have a customized column and I would like to multiply
two or three values in the same cell and be able to see
the subtotal in the same cell.
Please advise
Regards,
Majid

.

 

[Majid]

Thank you, I did create two columns and linked it to my
micro and it is working.

-----Original Message-----
Hello Majid,
Have you tried this formula in the Number3 field?
[Number1]*[Number7]

Hope this helps,

Gérard Ducouret

"Majid" <[email protected]> a écrit dans le message de

Hi Jack,
Thank you for your respond.
I have already "Number 1" for value entry and "Number 7"
for the product based on the micro. This micro is summing
the valuesfor the the filterd projects by the date range
and I am absolutely okay with it.
With respect to my problem, is there any way to customize
the customized column "number 1" to allow me to multiply
two numbers? Maybe I should create another column let
say "number 3" and link the product "number 3" to
my "number 7" which has the micro?
Please advisae.
Regards,
Majid

-----Original Message-----
A custom field can only return the value of the

formula.
It does not allow

direct input.
To do this you can insert other fields and use the formula to return the
value.

ie: use number1 and number2 for input, number3 to

return
their product using

the formula [number1]*[number2]

-Jack

I have a customized column and I would like to multiply
two or three values in the same cell and be able to see
the subtotal in the same cell.
Please advise
Regards,
Majid


.

.