Excel 2007 formula help

[Guest]

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)

 

[aidan.heritage]

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