Small adjustment needed for formula (#VALUE!)

[grrrrr]

Hi guys,

I have the following formula in place:

=CHOOSE(MAX(--AND(G$68>=I$71,H$68>=I$72,I$73>=1.3)*4,--AND(G$68>=I$71,H$68>=I$72)*3,--OR(G$68>=I$71,H$68>=I$72)*2,--AND(G$68<I$71,H$68<I$72)),MAX(H8*0.08,30),MAX(H8*0.1,40),MAX(H8*0.125,50),MAX(H8*0.15,60))

It works perfectly, but when 'H8' is blank, is comes up with #VALUE!

How can I change it? I thought to put brackets around it all and to say come out as 0 if H8 is blank but I don't know how to enter 'blank' into a formula

Thanks!!

 

[VoG]

I think your formula got cut of but it would be like

=IF(H8="",0,CHOOSE(MAX(--AND(G$68>=I$71,H$68>=I$72,I$73>=1.3)*4,--AND(G$68>=I$71,H$68>=I$72)*3,--OR(G$68>=I$71,H$68>=I$72)*2,--AND(G$68 ...

 

[grrrrr]

Superb.

Thanks VoG - I love this site