IF AND with Less and greater than is not working
I am trying to use this formula.
IF(AND([Time Remaining]@row = "Closed", [Closed Date ageing]@row >= 90,[Closed Date ageing]@row <= 180), "90-180 Days", "More")
where [Closed Date ageing]=203 but still it is giving output "More"
Can you please tell me where I'm making mistakes?
Help Article Resources
Check out the Formula Handbook template!