I need a single number showing what I’m paying monthly and yearly for tools, whether I pay for them monthly or yearly. I have a monthly and yearly column populated with costs. Then I added a formula column to calculate the cost per month where I pay yearly, but it doesn’t work. My formula looks like this - what is wrong?!
IF({Pd by Yr} > 0), DIVIDE({Pd by Yr},12)
I figured it out! Help to read the Function syntax instructions lol.
IF({Pd by Yr} > 0, {Pd by Yr}/12, {Pd by Yr})