View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default 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