MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Create an If, Then Formula In Numbers?

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:

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

Is there a way to write an if, then formula so I only have to update column A and it automatically figure C based in B?
—–
Michelle

Comments: One Response to “How Do I Create an If, Then Formula In Numbers?”

    5 months ago

    So the way to add a month to a date is to use EDATE. Look up this function in the help. Basically it takes a date and a number of months and returns that date plus that number of months. So exactly what you want.

    The IF function would just for an “M” and add 1 month if so, 3 months otherwise.

    So one way to do is is to have two different EDATE functions, and use an IF function to choose one if the letter is “M” and the other if it is not “M”.

    IF(B2=”M”,EDATE(A2,1),EDATE(A2,3))

    Or, you could use the IF function inside a single EDATE to choose either the number 1 or 3.

    EDATE(A3,IF(B3=”M”,1,3))

Comments Closed.