ExcelBanter - Excel 2007 formula help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel 2007 formula help (https://www.excelbanter.com/excel-worksheet-functions/155167-excel-2007-formula-help.html)

STEVE THE PARTS GUY

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)

[email protected]

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

All times are GMT +1. The time now is 03:13 AM.