Formula question

[Pipchacha]

Hi All,

i am after some help with a cell formula.

Situation.

I have ave a cell with a figure in it.
The cell below it I want to have the following.
If cell above is less then 273 than that cell shoul be 273

can someone please help me with this formula?

thankyou.

 

[Pipchacha]

Thanks, I will give it a go.

 

[Pipchacha]

You FORMR are a legend. Thanks so much.

 

[Pipchacha]

I have another one for you if that’s ok

 

[Pipchacha]

I have a cell that needs the following calculated

in cell if “A1”
is between 273 and 674 then value is 60
is between 675 and 1349 then value is 120
is between 1350 and 4044 then value is 185
is over 4045 the value is 250

 

[FormR]

I have another one for you if that’s ok

Hi, if it's totally unrelated then it would be best if you started a new thread.

EDIT, but that is fairly straight forward:

=LOOKUP(A1,{273,675,1350,4045},{60,120,185,250})