If function with calculation

  • Thread starter Thread starter Charlie
  • Start date Start date
C

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
 
Hi Charlie,

you're almost there with your description!

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