View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ozgrid.com ozgrid.com is offline
external usenet poster
 
Posts: 464
Default Using iserror with greater than

If you custom format the cell as:
[=6]General;;
you can simply use;

=SUM(D2,D8)


--
Regards
Dave Hawley
www.ozgrid.com
"smandula" wrote in message
...
Solution:
=IF(D2+D8=6,D2+D8, "") works with any = 6 or 7
as long as the linked page shows a number such as 0
not "" which will cause a #value!

So easy?