comotoman Wrote:
When i have formulas with there criteria not fullfilled, i get the
"#N/A". How do i get that to go away?

One way ...

=IF(ISERROR(YOUR_FORMULA),\" \",YOUR_FORMULA)

will take care of this problem of yours.


Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=468285