Single cell formula

[Ronda]

I need to create a formula in a single cell that will take my existing data
and multiply it by a percent. I do not have the option of adding another
column so I must format all in one cell. (i.e. 350 X 8%)

 

[Jack Dahlgren]

so, if the 350 is in a field (lets use cost for this example) just make a new
field which refers to this field and do the multiplication.


[Cost] * 0.08

If you want further formatting (like a dollar sign)
use a text field and the format command or concatenation

"$" & [Cost] * 0.08


-Jack Dahlgren

 

[Rod Gill]

No problems, but the formula can only be in a custom field. What field holds
the 350, what format do you want, what version of Project?

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Ronda]

I thought that was going to work but I have a column that has about 3,000
rows and the (cost) changes in each cell so I need to have a formula that
will hold the (cost) that already exists but multiply it by 8%

so, if the 350 is in a field (lets use cost for this example) just make a new
field which refers to this field and do the multiplication.


[Cost] * 0.08

If you want further formatting (like a dollar sign)
use a text field and the format command or concatenation

"$" & [Cost] * 0.08


-Jack Dahlgren

I need to create a formula in a single cell that will take my existing data
and multiply it by a percent. I do not have the option of adding another
column so I must format all in one cell. (i.e. 350 X 8%)

 

[Jack Dahlgren]

Which cost that already exists? Is it baseline cost?
In that case use [Baseline Cost] * 0.08

-Jack Dahlgren

I thought that was going to work but I have a column that has about 3,000
rows and the (cost) changes in each cell so I need to have a formula that
will hold the (cost) that already exists but multiply it by 8%

so, if the 350 is in a field (lets use cost for this example) just make a new
field which refers to this field and do the multiplication.


[Cost] * 0.08

If you want further formatting (like a dollar sign)
use a text field and the format command or concatenation

"$" & [Cost] * 0.08


-Jack Dahlgren

I need to create a formula in a single cell that will take my existing data
and multiply it by a percent. I do not have the option of adding another
column so I must format all in one cell. (i.e. 350 X 8%)

 

[Gérard Ducouret]

Hi Jack,

I'm not sure, but don't you think that Ronda want somethnig like a VBA macro
to increase his column values by 8% ?

Gérard Ducouret

Which cost that already exists? Is it baseline cost?
In that case use [Baseline Cost] * 0.08

-Jack Dahlgren

I thought that was going to work but I have a column that has about 3,000
rows and the (cost) changes in each cell so I need to have a formula that
will hold the (cost) that already exists but multiply it by 8%

so, if the 350 is in a field (lets use cost for this example) just make
a new
field which refers to this field and do the multiplication.


[Cost] * 0.08

If you want further formatting (like a dollar sign)
use a text field and the format command or concatenation

"$" & [Cost] * 0.08


-Jack Dahlgren


:

I need to create a formula in a single cell that will take my
existing data
and multiply it by a percent. I do not have the option of adding
another
column so I must format all in one cell. (i.e. 350 X 8%)

 

[Ronda]

I am working with an excel 2003 document that I can not change the format of
in any way. What I need to do is increase the cost that is currently entered
in the cell by 8%. When I try to enter the formula I am getting a circular
reference error.

 

[Gérard Ducouret]

Ronda,

Are you using Excel or MS Project ? Here is a news group dedicated to MS
Project, a planning tool.
Anyway, I think that only a VBA procedure can do what you want.

Gérard Ducouret

 

[Jack Dahlgren]

Perhaps you are right. It is hard to tell. That is why I asked for more
information.

-Jack

Hi Jack,

I'm not sure, but don't you think that Ronda want somethnig like a VBA macro
to increase his column values by 8% ?

Gérard Ducouret

Which cost that already exists? Is it baseline cost?
In that case use [Baseline Cost] * 0.08

-Jack Dahlgren

I thought that was going to work but I have a column that has about 3,000
rows and the (cost) changes in each cell so I need to have a formula that
will hold the (cost) that already exists but multiply it by 8%

:

so, if the 350 is in a field (lets use cost for this example) just make
a new
field which refers to this field and do the multiplication.


[Cost] * 0.08

If you want further formatting (like a dollar sign)
use a text field and the format command or concatenation

"$" & [Cost] * 0.08


-Jack Dahlgren


:

I need to create a formula in a single cell that will take my
existing data
and multiply it by a percent. I do not have the option of adding
another
column so I must format all in one cell. (i.e. 350 X 8%)