Forum Discussion
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 date and add 60 days
If I2 is less than 85 it should take today's date and add 30 days
I tried
=IF(I2>92,"TODAY()=90",IF(I2<85,"TODAY()=30",IF(I2>84)&(I2<92),TODAY()=60))))
but it says there is something wrong.
Can anyone help?
2 Replies
Alternatively
=TODAY()+((I2>92)+(I2>=85)+1)*30
Pamela,
Try this formula:
=IF(I2>92,EDATE(TODAY(),3),IF(AND(I2>=85,I2<=92),EDATE(TODAY(),2),IF(I2<85,EDATE(TODAY(),1))))
