MacMusic  |  PcMusic  |  440 Software  |  440 Forums  |  440TV  |  Zicos
column
Search

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

Monday November 19, 2018. 04:10 AM , from MacMost
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
https://macmost.com/forum-how-do-i-create-an-if-then-formula-in-numbers.html
News copyright owned by their original publishers | Copyright © 2004 - 2024 Zicos / 440Network
Current Date
Nov, Thu 21 - 15:42 CET