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.

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.

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

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.