IF result is a "0" the leave a blank.

[bullcreel]

This formula is not working...

=IF(BS17="R",VLOOKUP('bat calcs'!$AN$28,tab,3),VLOOKUP('bat calcs'!$AN$28,tab,4))="","",if(BS17="R",vlookup('bat calcs'!$AN$28,tab,3),VLOOKUP('bat calcs'!$AN$28,tab,4)

The formula below is working fine...

=IF(VLOOKUP(calculations!$M$14,NegTable!$A$80:$I$155,8)="","",VLOOKUP(calculations!$M$14,NegTable!$A$80:$I$155,8))

Please let me know what is wrong with first formula?

 

[shaowu459]

=IF(IF(BS17="R",VLOOKUP('bat calcs'!$AN$28,tab,3),VLOOKUP('bat calcs'!$AN$28,tab,4))="","",if(BS17="R",vlookup('bat calcs'!$AN$28,tab,3),VLOOKUP('bat calcs'!$AN$28,tab,4))

 

[Peter_SSs]

I think even one more parenthesis is needed
=IF(IF(BS17="R",VLOOKUP('bat calcs'!$AN$28,tab,3),VLOOKUP('bat calcs'!$AN$28,tab,4))="","",IF(BS17="R",VLOOKUP('bat calcs'!$AN$28,tab,3),VLOOKUP('bat calcs'!$AN$28,tab,4)))

 

[bullcreel]

That worked beautifully...thankyou so much...never used if(if( before

 

[Peter_SSs]

That worked beautifully...thankyou so much...never used if(if( before

You are welcome.