#VALUE! error in if formula

[mkmed]

Hello all,

The following formula is working onall counts except when cell n4 is blank. My desire is to have the cell that the formula resides in to be blank if n4 is blank, but instead I get aValue error

=IF(N4>0,IF('Project info'!$B$8=50,D4/N4*10,IF('Project info'!$B$8=60,D4/N4*12,IF('Project info'!$B$8=40,D4/N4*8,IF(N4="",0)))),0)

Thanks for any help,
Mark

[arthurbr]

This should to the trick

=IF(isblank(n4),"",if(N4>0,IF('Project info'!$B$8=50,D4/N4*10,IF('Project info'!$B$8=60,D4/N4*12,IF('Project info'!$B$8=40,D4/N4*8,IF(N4="",0)))),0))

[mkmed]

Still getting the same error. Any other ideas??

mark

[NBVC]

=IF(N4="","",IF('Project info'!$B$8=50,D4/N4*10,IF('Project info'!$B$8=60,D4/N4*12,IF('Project info'!$B$8=40,D4/N4*8,IF(N4="",0)))))

[mkmed]

Thanks for all your help. Working great!!!


Mark