Conditional Formula

[Dsheaff]

I am in need of a formula that addresses the following conditions.

A recipient cell is to receive the value posted in cell D35 on the QC Enhanced Score worksheet found at the location identified below: This action is to take place only if the value in cell U90 on the afore mentioned worksheet is equal to or greater than 1 but less than 90. If these conditions are not met, the recipient cell is to remain blank.

Worksheet Location:

='M:\Quality\REST\2023\B-Feb\A-21 Enhanced Facility Score\[Enhanced Facility Score Feb 2023.xlsx]QC Enhanced Score'!D35

 

[Fluff]

In that case you need to change the name of the file in the formula.

 

[Dsheaff]

Ok, how about

=IF(AND('M:\Quality\REST\2023\B-Feb\A-21 Enhanced Facility Score\[Enhanced Facility Score Feb 2023.xlsx]QC Enhanced Score'!U90>=1,'M:\Quality\REST\2023\B-Feb\A-21 Enhanced Facility Score\[Enhanced Facility Score Feb 2023.xlsx]QC Enhanced Score'!U90<90),'M:\Quality\REST\2023\B-Feb\A-21 Enhanced Facility Score\[Enhanced Facility Score Feb 2023.xlsx]QC Enhanced Score'!D35,"")

Please excuse the error in my last transmittal... I omitted two of the adjustments from A-21 to A2I_.....The corrected formula I posted should be:
=IF(AND('M:\Quality\REST\2023\B-Feb\A2I-Enhanced Facility Score\[Enhanced Facility Score Feb 2023.xlsx]QC Enhanced Score'!U90>=1,'M:\Quality\REST\2023\B-Feb\A2I-Enhanced Facility Score\[Enhanced Facility Score Feb 2023.xlsx]QC Enhanced Score'!U90<90),'M:\Quality\REST\2023\B-Feb\A2I-Enhanced Facility Score\[Enhanced Facility Score Feb 2023.xlsx]QC Enhanced Score'!D35,"")

 

[Fluff]

That formula contains the month name, but according to post#10 it's not in the file name.

 

[Dsheaff]

That formula contains the month name, but according to post#10 it's not in the file name.

Your formula works... I found an error in the way I identified a worksheet ... a single alpha character ... I thank you ever so much for your help and guidance!!!

 

[Fluff]

Glad we could help & thanks for the feedback.