Using iserror with greater than

S

smandula

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
 
B

Bob Phillips

This should be fine

=IF(D2+D8>6,D2+D8,"")

regardless of whether D2 is blank or not
 
J

JLGWhiz

This will test for D2+D8>=6 and add D2+D8 if true, otherwise = nullstring

=IF(D2+D8>=6,D2+D8, "")

If D2 is empty it will not throw an error since Excel sees blank as zero.
It will just add D8 value to zero to test if it equals or exceeds 6.
 
S

smandula

Thanks for your reply.

I tried that solution before I posted.

What I did not say is that D2 on Sheet 3
is linked with sheet called Form ie =Form!$D$12
which is the reason I need iserror to get rid of the #value!

I would appreciate any suggestions
 
S

smandula

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?
 
O

ozgrid.com

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

=SUM(D2,D8)
 
Top