=OR(IF(AND(....),HYPERLINK....
 

I need to have a formula that says if one cell says CO and another says Y
then another cell links off to the hyperlink otherwise it says pending. This
is fine and it works:

=IF(AND(AQ61="Y",B61="CO"), HYPERLINK($AW$61&C61&".pdf","Approved"),"Pending")


However the cell that says CO can also say PO and these will hyperlink off
to somewhere else so I need to do an OR function. I did a simple version
with TRUE/FALSE instead of the hyperlink and that works fine:


=OR(IF(AND(AQ61="Y",B61="CO"),TRUE,FALSE),IF(AND(A Q61="Y",B61="PO"),TRUE,FALSE))

However when I put the hyperlink in it comes back as #VALUE:

=OR(IF(AND(AQ61="Y",B61="CO"),
HYPERLINK($AW$61&C61&".pdf","Approved"),"Pending") ,IF(AND(AQ61="Y",B61="PO"),
HYPERLINK($AW$60&C61&".pdf","Approved"),"Pending") )


Does anyone have any ideas what I need to change to make it work please?
Thanks.

=OR(IF(AND(....),HYPERLINK....
 

Think it's just an error in the IF construct ..

This is incorrect:
=OR(IF(AND(AQ61="Y",B61="CO"),TRUE,FALSE),IF(AND(A Q61="Y",B61="PO"),TRUE,FALSE))

It should be structured as something like this:
=IF(AND(AQ61="Y",B61="CO"),"Hyper1",IF(AND(AQ61="Y ",B61="PO"),"Hyper2","Pending"))

Above applied with your working hyperlinks inserted:

=IF(AND(AQ61="Y",B61="CO"),HYPERLINK($AW$61&C61&". pdf","Approved"),IF(AND(AQ61="Y",B61="PO"),HYPERLI NK($AW$60&C61&".pdf","Approved"),"Pending"))

should work fine
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"zx6roo" wrote:
I need to have a formula that says if one cell says CO and another says Y
then another cell links off to the hyperlink otherwise it says pending. This
is fine and it works:

=IF(AND(AQ61="Y",B61="CO"), HYPERLINK($AW$61&C61&".pdf","Approved"),"Pending")


However the cell that says CO can also say PO and these will hyperlink off
to somewhere else so I need to do an OR function. I did a simple version
with TRUE/FALSE instead of the hyperlink and that works fine:


=OR(IF(AND(AQ61="Y",B61="CO"),TRUE,FALSE),IF(AND(A Q61="Y",B61="PO"),TRUE,FALSE))

However when I put the hyperlink in it comes back as #VALUE:

=OR(IF(AND(AQ61="Y",B61="CO"),
HYPERLINK($AW$61&C61&".pdf","Approved"),"Pending") ,IF(AND(AQ61="Y",B61="PO"),
HYPERLINK($AW$60&C61&".pdf","Approved"),"Pending") )


Does anyone have any ideas what I need to change to make it work please?
Thanks.

=OR(IF(AND(....),HYPERLINK....
 

You look at these functions for too long you can't see the obvious!
Thanks heaps Max.

=OR(IF(AND(....),HYPERLINK....
 

welcome, glad that sorted it for you.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"zx6roo" wrote in message
...
You look at these functions for too long you can't see the obvious!
Thanks heaps Max.