I need an if then statement that does the following:
So far this is what I have come up with:
=if(c2="jan",b2/12,0)
If the statement is true how do I get it to go feb-dec. If it is not true how do I get it to jump to feb and continously do the same thing until it gets to dec?
So far this is what I have come up with:
=if(c2="jan",b2/12,0)
If the statement is true how do I get it to go feb-dec. If it is not true how do I get it to jump to feb and continously do the same thing until it gets to dec?
Last edited: