Search results

Brian that worked perfectly! Now I am curious on the VBA's you were talking about, I have to go research that. I think on my own time I am going to take an intermediate course in excel so i can stand out amongst my peers because we receive no training in this whatsoever. Thank you again!

That would be correct. I have not learnt that. Excel amazes me, I just do not know how to work it to the "wow" factor.

Brian- Close. However, Lets say if I am adding a new employee and I they will not start until May. How do I get it to divide what I want to pay the employee by 12 place that number in the may-dec columns and place a 0 in the jan-apr columns. So in b2 is the salary c2 is the hire month

I understand that. I have never posted anything on any website, blog, or etc. I just wanted some help. I have tried everything that I can think of =if(c2="jan"b2/12,0)....(c2="dec"b2/12,0) Obviously that didn't work. I can sit here and be ridiculed about my choice of words in a blog or I...

I am currently not in any courses as school has not started yet. However my degree required me to take a basic MS Office course which I passed with flying colors. My degree is in business and I did a budget for an internship. That was done easily but now that I am done I thought wouldnt it be...

The code is not for an assignment. My assignment is done. I manually did the work, i just thought it would be cool to do it automatically. Thanks for the code!

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?