Using iserror with greater than

[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

 

[Bob Phillips]

This should be fine

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

regardless of whether D2 is blank or not

 

[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.

 

[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

 

[smandula]

I get an error mesage on this submission

=IF(D2+D8>7,D2+D8,IFERROR(D2+D8),"",)

 

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

 

[ozgrid.com]

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

=SUM(D2,D8)