Assign a value to a cell

R

rodolform

I'll apreciate your help with this

in A1 i have a value in days that is used to make several calculations
but I need it to change if a specific condition is given something lik
this:

A1=300
If b1<a1 then a1=b1
where b1 is a value calculated somewhere else.

Thank you for your help.

Rodolf
 
R

rodolform

Frank:

Thank's for your help, but with your sugestión A1 will always b
compared with 300, and in my case A1 is a variable value wich I ente
to make the calculation, and if a specific condition is meet it the
needs to change its value.

I'll apreciate any comments...

Rodolf
 
B

Bob Phillips

Then you can't do what you want, as your are trying to have A1 hold a value
and a formula. Can't do both, you need another cell.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
F

Frank Kabel

Hi
or at least you can't do this without using VBA (using the
worksheet_change event).
I would therefore suggest (as Bob does) you create an entry cell for
your value and use the formula provided to you in a new cell. Use this
cell as basis for your other calculations

Frank
 
R

rodolform

Thank you,

You're rigth, I need to use another cell and from there take th
value.....

It was so obvious but I became clear until you mentioned.

Thank's again....
Rodolfo
 
Top