| Home |
| Search |
| Today's Posts |
|
#1
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 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If function with Calculation | Excel Worksheet Functions | |||
| Date calculation function? | Excel Worksheet Functions | |||
| IF Function - Calculation not working | Excel Worksheet Functions | |||
| How do you know which function to use for a calculation? | Excel Worksheet Functions | |||
| Calculation within IF function | Excel Worksheet Functions | |||
Threaded Mode
