قالب وردپرس درنا توس
Home / Mac / How do I make an if, so formula in numbers? – MacMost

How do I make an if, so formula in numbers? – MacMost




11/18/18
8:10 pm

I have column A with dates, column B with letters like M (monthly), Q (quarterly), etc; Column C is A (date) plus 1 month if column B is M; plus 3 if Q.

Example:

1. June 2018. M. 1 July 2018
June 1, 2017. Q. September 1, 2018

Is there a way to write an if, then the formula, so I just need to update column A and that figure C automatically in B?

Michelle



Source link