Hello! I would like to use a simply “IF” statement, to calculate total annual cost based on if something is a monthly, or annual cost.
In this table below, I want to use “Annual Cost” field for a formula. I would like to have that formula check if “Bill Period = “Monthly”” then, multiply Cost*12, otherwise just have Cost = Cost. Does that make sense? Any tips?