If function with calculation
in [Functions]
|
Prev: Merge Cells
Next: 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" <Charlie(a)discussions.microsoft.com> 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" <stunn(a)sky.com> 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" <Charlie(a)discussions.microsoft.com> 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" <stunn(a)sky.com> 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" <Charlie(a)discussions.microsoft.com> 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" <Charlie(a)discussions.microsoft.com> 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 Cells Next: formating |