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

 

[awoohaw]

in the target cell put this formula:

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

(I'm pretty sure the workbook M:\Quality\REST\2023\B-Feb\A-21 Enhanced Facility Score\Enhanced Facility Score Feb 2023.xlsx must be open when you are making the calculations.

 

[Dsheaff]

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

I have corrected the following information I initially provided Cell parameters from U90 to U35 and the file reference from A-21 Enhanced to A2I-Enhanced. The revised formula ais as follows: =IF(and(U35=1, U35<90),='M:\Quality\REST\2023\B-Feb\A2I-Enhanced Facility Score\[Enhanced Facility Score Feb 2023.xlsx]QC Enhanced Score'!D35,"") Unfortunately it still does not work.

 

[awoohaw]

okay. I see a big error initially in what I did. There is also a random equals sign that should be removed. The "AND" function is redundant, sort of... Maybe it should be

AND(U35>=1,U35<90)

=IF(and(U35>=1, U35<90),'M:\Quality\REST\2023\B-Feb\A2I-Enhanced Facility Score\[Enhanced Facility Score Feb 2023.xlsx][U]QC Enhanced Score[/U]'!D35,"")

 

[Dsheaff]

okay. I see a big error initially in what I did. There is also a random equals sign that should be removed. The "AND" function is redundant, sort of... Maybe it should be

AND(U35>=1,U35<90)

=IF(and(U35>=1, U35<90),'M:\Quality\REST\2023\B-Feb\A2I-Enhanced Facility Score\[Enhanced Facility Score Feb 2023.xlsx][U]QC Enhanced Score[/U]'!D35,"")

 

[Dsheaff]

The solution provided does not work. This issue remains unresolved and additional response(s) are welcome.

 

[Fluff]

Is U90 on the same sheet as the formula or on the QC Enhanced Score sheet?

 

[Dsheaff]

It resides on the same sheet as the QC Enhanced Score worksheet

 

[Fluff]

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

 

[Dsheaff]

Below is the formula... slightly modified to reflect a correction in the address (from A-21 Enhanced Facility Score to A2I-Enhanced Facility Score). Everything else as you can see below remains the same as the formula you provided. I have also pasted the location file path as it appears on the bar at the top of the screen when I first open the folder containing the file. The last element below is a copy of the subject file. Note that when I apply this formula to the target it does not work. I receive a Microsoft pop-up that states as follows...Excel found a problem with one or more formula references in the worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct. Additionally, upon entering the formula, the M in the formula is shaded in light gray and the following appears in a rectangular box below the formula bar... AND(logical1,[logical2], [logical3], ...)

=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\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,"")

File Path: M:\Quality\REST\2023\B-Feb\A2I-Enhanced Facility Score
File as it appears in the file path: Enhanced Facility Score 2023