Dohhhhhhhhhhh - Cheers Andy. So used to testing for it as opposed to
creating one - grrrrrrrrr - :-)
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Andy Pope" wrote in message
...
Hi Ken,
I think you meant NA() instead of ISNA().
=IF(H14=0,NA(),1780/H14)
Cheers
Andy
Ken Wright wrote:
Try =IF(H14=0,ISNA(),1780/H14)
Depends on what kind of chart chart though?
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info