Help With Formula Containing A Reference To Another Sheet

[CaliKidd]

I have a formula which tests 3 different conditions and if all three conditions are met, then it results in a "Pass", otherwise it results in a "Fail".

I would like to modify the following formula

=IF(AND(J6<=M6,J6>=L6,P6<=100),"Pass","Fail")

Instead of hardcoding the value 100, however, I would like to use a reference instead so I can change the value as needed.

If I put that variable in cell A1 of a different sheet (Sheet 2), what would the resulting formula be?

 

[VoG]

Try

=IF(AND(J6<=M6,J6>=L6,P6<=Sheet2!$A$1),"Pass","Fail")

 

[CaliKidd]

Thank you, Peter.