Thread: How to get rid of #Value!
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
day[_2_] day[_2_] is offline
external usenet poster
  
Posts: 7
Default How to get rid of #Value!
So never mind.. I think I solved it for the mean time. I used the
following only b/c I don't know how to use the other ISNUM, AND OR....
=IF(B6=-(B9),B6,IF(B6<0, (B9+B6),IF(B6=0,"$0.00",(B9*B7)-B6)))

this is fun

Reply With QuoteReply With Quote