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
|