IF function

[DilshanSomanayake]

Can you please help me in IF Function

I need to use a condition where result should be yes comparing a range 

If days between 30 to 60 = result should be "Yes" 

[#2 · Accepted solution]

@DilshanSomanayake 

Let's say the number of days is in D2, D3 etc.

=IF(AND(D2>=30,D2<=60),"Yes","No")

This can be filled or copied down.

[#3]

Very much appreciated on your quick response