increment every june a fixed amount

[PKBrahma]

Sir,
I've a column(A) having months from January 2014 to January 2018. In column(B), I have my salary. Every year in June, I get an increment of 100 rupees which is added to my salary. if in January 2014, my salary is 2000, from June 2014, it is 2100 till May 2015. From June 2015 to May 2016, my salary will be 2200, from June 2016 to May 2017, it is 2300 like this. Can if be made through programming? Or should I do it manually by adding 100 rupees every June? I will be happy to get a reply for this. Thanks very much.

 

[ExcelRaja]

Hi Pls try the below formula in Column B Row 3

Assume Column B Row 2 is 2000

=IF(MONTH(A3)=6,B2+100,B2)

 

[Joe4]

Are your entries in column A actual dates, or text?
If you aren't sure, go to one of the entries, and see what formatting is applied to that cell and let us know (General, Text, or some Custom Date format).

 

[JazzSP8]

Assuming you have a date formatted "Jan 2014" in A2 then;

In B2 put the number 2000

In B3 put the formula;

=IF(MONTH(A3)=6,B2+100,B2)

And drag it down.

 

[PKBrahma]

Sir, it worked fantastic. Thank you. But, in place of fixed 100 rupees in increment, if I make an increment of 10% of the salary of May every year in June, how to write to write it?

 

[PKBrahma]

Thank you sirs. I could write for myself being inspired. Thanks to all and regards.

 

[PKBrahma]

sir,
I am again stuck with a new problem. Every June when I get increment i.e. salary*3%, the amount comes to say 7582. 7582 should be the next number of multiple of 10 i.e.7590. If it is 7581 or less, it should be 7580. If it is more than 7581.01, then it will be 7590. Perhaps, ceiling or floor function will be used with mod. if mod(cell no),10)>1, ceiling(cell no,10), floor(cell no,10). But, I don't know where to write it inside the above code:
=IF(MONTH(A3)=6,B2+100,B2)
Please guide me. Thanks.

 

[Joe4]

Try this:

=IF(MONTH(A3)=6,IF(MOD(B2*1.03,10)>1,ROUNDUP(B2*1.03,-1),ROUNDDOWN(B2*1.03,-1)),B2)

 

[PKBrahma]

Sir,
Thank you so much for quick reply. My work done. Regards.

 

[Joe4]

You are welcome.