Prev: Merge CellsNext: formating From: Charlie on 12 Apr 2010 06:13 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 From: Steve Dunn on 12 Apr 2010 06:28 Hi Charlie, you're almost there with your description! =IF(B20=0,0,IF(B20<35,35,B20)) "Charlie" wrote in message news:F22F73BA-CDF8-4038-BFED-0E6ACCF56F97(a)microsoft.com...> 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 > From: Steve Dunn on 12 Apr 2010 06:35 You could also use: =IF(B20=0,0,MAX(35,B20)) "Steve Dunn" wrote in message news:9A2DF673-CED4-4DDD-A323-A9D8D6CE37A3(a)microsoft.com...> Hi Charlie, > > you're almost there with your description! > > =IF(B20=0,0,IF(B20<35,35,B20)) > > > > > "Charlie" wrote in message > news:F22F73BA-CDF8-4038-BFED-0E6ACCF56F97(a)microsoft.com... >> 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 >> > From: Steve Dunn on 12 Apr 2010 06:39 Or even: =MAX(35,A1)*(A1<>0) "Steve Dunn" wrote in message news:9A2DF673-CED4-4DDD-A323-A9D8D6CE37A3(a)microsoft.com...> Hi Charlie, > > you're almost there with your description! > > =IF(B20=0,0,IF(B20<35,35,B20)) > > > > > "Charlie" wrote in message > news:F22F73BA-CDF8-4038-BFED-0E6ACCF56F97(a)microsoft.com... >> 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 >> > From: Charlie on 12 Apr 2010 08:35 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 > news:F22F73BA-CDF8-4038-BFED-0E6ACCF56F97(a)microsoft.com... > > 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 > > >  |  Pages: 1 Prev: Merge CellsNext: formating