Forum Discussion
mandy barber
Nov 07, 2018Copper Contributor
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...
- Nov 07, 2018
That could be
=M2+90+IF(P2>=1000,30,)
SergeiBaklan
Nov 07, 2018Diamond Contributor
That could be
=M2+90+IF(P2>=1000,30,)
- mandy barberNov 07, 2018Copper Contributor
I so appreciate you Sergei!! Thanks so much for your assistance.
- SergeiBaklanNov 07, 2018Diamond Contributor
You are welcome