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.

 

[steve the fish]

Hi. What should the cell say if the cell above is more than or equal to 273?

 

[FormR]

If cell above is less then 273 than that cell shoul be 273

Hi, maybe your looking for:

=MAX(273,A1)

 

[Pipchacha]

If the value of the cell Is less than 183 it needs to change to zero
if the cell value is between 184 and 273 it needs to change to 283

 

[FormR]

If the value of the cell Is less than 183 it needs to change to zero
if the cell value is between 184 and 273 it needs to change to 283

Are these in addition to the condition specified in your first post? i.e. if it's greater than 273 the result should be 273? Is that really 273 or 283?

 

[Pipchacha]

273 sorry it was a typo

 

[Pipchacha]

They were not in addition. These are the formulas I need to know.

 

[FormR]

They were not in addition.

So what happens if it's above 273?

 

[Pipchacha]

It’s for warranty on a product.
Based on a percentage of purchase.
If purchase above 20000 warranty is calculated at 0.91%
but it has a minimum of 273
cell calculates warranty at 182
if under 183 then it should be 0
if above 183 but under 274 is should be 273
once above 273 it continues to rise

 

[FormR]

You can give this a try, assumes the cell in question is A1.

=IF(A1<183,0,MAX(273,A1))