View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default Using iserror with greater than

This should be fine

=IF(D2+D86,D2+D8,"")

regardless of whether D2 is blank or not

--

HTH

Bob

"smandula" wrote in message
...
I am having trouble and would like to use greater than

=IF(ISERROR(D2+D8),"",D2+D8)

I need a condition if D2+D8=6 if it does then
add D2+D8 all the while using iserror if D2 happens
to be blank

With Thanks