Forum Discussion

mandy barber's avatar
mandy barber
Copper Contributor
Nov 07, 2018
Solved

If this then that formula

I am trying to figure out a formula that if P2 is >=1000 add 120 days to the date in M2 in cell O2, if P2 is <=999 add 90 days to the date in M2 in cell O2. I cannot seem to get it to return a correc...
  • SergeiBaklan's avatar
    Nov 07, 2018

    That could be

    =M2+90+IF(P2>=1000,30,)

Resources