| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 formula help
I need to modify the formula below so that if cell AA6 is blank the result
will be blank. It currenly gives a result of the Min of 2.95. Thanks in advance. Steve =Labor!$A$1*AA6+MIN(MAX(Labor!$A$1*AA6*0.1,2.95 ),24.95) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2007 formula help
On 21 Aug, 14:04, STEVE THE PARTS GUY
wrote: I need to modify the formula below so that if cell AA6 is blank the result will be blank. It currenly gives a result of the Min of 2.95. Thanks in advance. Steve =Labor!$A$1*AA6+MIN(MAX(Labor!$A$1*AA6*0.1,2.95 ),24.95) =if(isblank(AA6),"",Labor!$A$1*AA6+MIN(MAX(Labor!$ A$1*AA6*0.1,2.95 ), 24.95) ) should do it for you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2007 formula | Excel Worksheet Functions | |||
| Excel 2007 - Formula Bar Format | Excel Discussion (Misc queries) | |||
| Excel 2007 does not save formula | Excel Discussion (Misc queries) | |||
| Excel 2007 Formula Display | Excel Discussion (Misc queries) | |||
Linear Mode
