IF AND with Less and greater than is not working

Suman Kumar

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?

Thank You

Suman

markkrebs

What result do you want for 203? your formula will correctly give 90-180 Days if the aging is 90 to 180 AND closed.