Forum Discussion
Pamela Haskins
Feb 01, 2018Copper Contributor
Excel
I cannot figure out how to write the following formula so Excel will accept it:
If I2 is >92 I want it to take today/s date plus 90 days
If I2 is between 85 and 92 then it should take today's...
SergeiBaklan
Feb 02, 2018Diamond Contributor
Alternatively
=TODAY()+((I2>92)+(I2>=85)+1)*30