minimum cell value

[Doug Bell]

Hi,

I am trying to set up a cell so it has a minimum value.

The current formula is: =a1/a2*5 which gives the answer 0 but i need to show
a minimum value of 1 is this possible?

 

[Norman Jones]

Hi, Doug,

Try:

=Max(a1/a2*5,1)

 

[Steve Farrar]

=MIN(A1/A2*5,1)