Using iserror with greater than
 

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

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

Using iserror with greater than
 

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" 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

Using iserror with greater than
 

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

Using iserror with greater than
 

I get an error mesage on this submission

=IF(D2+D87,D2+D8,IFERROR(D2+D8),"",)

Using iserror with greater than
 

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?

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?