In the 3rd column, I wish to introduce a formula which will automatically read the entry in column "Payment Model". If the entry is, "Yearly" it will just copy the value from column "Amount". If the entry is, "Monthly" it will multiply the value with 12.

Thanks in advance

Tried using the "if" statement, its not working. Here is my formula: =IF($B2 == "Yearly",$A2*1,$A2*12)

Throws me a Formula error everytime.

CodePudding user response：

Excel does not use the double equals.
The formula you want, provided by