If function with calculation
 

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

If function with calculation
 

Hi Charlie,

you're almost there with your description!

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




"Charlie" wrote in message
...
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

If function with calculation
 

You could also use:

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



"Steve Dunn" wrote in message
...
Hi Charlie,

you're almost there with your description!

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




"Charlie" wrote in message
...
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

If function with calculation
 

Or even:

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


"Steve Dunn" wrote in message
...
Hi Charlie,

you're almost there with your description!

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




"Charlie" wrote in message
...
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

If function with calculation
 

Perfect thank you

"Steve Dunn" wrote:

Hi Charlie,

you're almost there with your description!

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




"Charlie" wrote in message
...
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