MLSNetworks
New Member
- Joined
- Jun 6, 2019
- Messages
- 17
I am trying to create an IF AND formula that looks at a cell with a Date to see if it is 30 days from Today and then looks at another cell with a ranking percent and return true/false text.
Below is my formula which is not working.
=IF(AND(D2=TODAY()+30,G2<0.8),"OK","REVIEW")
What is a better formula?
Thanks for any help you can provide!
Below is my formula which is not working.
=IF(AND(D2=TODAY()+30,G2<0.8),"OK","REVIEW")
What is a better formula?
