If function with calculation

[Charlie]

Hi All,

I need to get a result from the following:

IF B20 = 0,0 IF B20<35, 35 IF B20> 35=B20

Basically in layman terms if B20 has a value above 0 the minimum showing is
35 if it is higher than 35 then it remains the same, 0 must remain 0.

Any help would be great

 

[Steve Dunn]

Hi Charlie,

you're almost there with your description!

=IF(B20=0,0,IF(B20<35,35,B20))

 

[Steve Dunn]

You could also use:

=IF(B20=0,0,MAX(35,B20))

Hi Charlie,

you're almost there with your description!

=IF(B20=0,0,IF(B20<35,35,B20))

 

[Steve Dunn]

Or even:

=MAX(35,A1)*(A1<>0)

Hi Charlie,

you're almost there with your description!

=IF(B20=0,0,IF(B20<35,35,B20))

 

[Charlie]

Perfect thank you

Hi Charlie,

you're almost there with your description!

=IF(B20=0,0,IF(B20<35,35,B20))