Excel 2007 formula help

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
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)
Click to expand...

=if(isblank(AA6),"",Labor!$A$1*AA6+MIN(MAX(Labor!$A$1*AA6*0.1,2.95 ),
24.95) )


should do it for you
 
Back
Top