Hi I need to find the the average annual salary using the salary per month data.
I know one can use another column for the salary per year and work it out, but I do not want to, since I am trying to make the application as efficient as possible.
Thanks
Maybe I'm misunderstanding what you're trying to achieve, but it looks like =SUM(B2:B4)*12/3
should do it. Or even better, =AVERAGE(B2:B4)*12
, or =A7*12
since you already have the average number in its own cell.