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
|