If statement

[rbpd5015]

Below is my if statement, what I need is a part added so that if d3 is blank " " that the formula is stopped and the cell is left " "
the way it goes now is it still goes through the forumla and leaves me with a junk number.

thanks
Matt

Please Login or Register  to view this content.

[martindwilson]

=IFERROR(if(d3="","",IF(D3<0,D3*(('MLB OVERALL'!$X$6*'MLB OVERALL'!$D$3)+'WEEK 1A'!$A$2)/-100,
(('MLB OVERALL'!$X$6*'MLB OVERALL'!$D$3)+'WEEK 1A'!$A$2)/'MLB OVERALL'!$X$6*100)), "")

[rbpd5015]

Thanks,

works perfect

Matt