|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 12th, 2010, 11:13 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If function with calculation
Hi All,
I need to get a result from the following: IF B20 = 0,0 IF B2035, 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 
|
|
#2
April 12th, 2010, 11:28 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If function with calculation
Hi Charlie,
you're almost there with your description! =IF(B20=0,0,IF(B2035,35,B20)) "Charlie" wrote in message ... Hi All, I need to get a result from the following: IF B20 = 0,0 IF B2035, 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
|
|
#3
April 12th, 2010, 11:35 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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(B2035,35,B20)) "Charlie" wrote in message ... Hi All, I need to get a result from the following: IF B20 = 0,0 IF B2035, 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
|
|
#4
April 12th, 2010, 11:39 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If function with calculation
Or even:
=MAX(35,A1)*(A10) "Steve Dunn" wrote in message ... Hi Charlie, you're almost there with your description! =IF(B20=0,0,IF(B2035,35,B20)) "Charlie" wrote in message ... Hi All, I need to get a result from the following: IF B20 = 0,0 IF B2035, 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
|
|
#5
April 12th, 2010, 01:35 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If function with calculation
Perfect thank you
"Steve Dunn" wrote: Hi Charlie, you're almost there with your description! =IF(B20=0,0,IF(B2035,35,B20)) "Charlie" wrote in message ... Hi All, I need to get a result from the following: IF B20 = 0,0 IF B2035, 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
