Assign a value to a cell

  • Thread starter Thread starter rodolform
  • Start date Start date
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
 
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
 
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)
 
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
 
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
 
Back
Top