dear all,
this is varun,plz help me to solve this sum problem.this is the increment sheet & when a worker present 31 days he gets 200/- increment in his monthly salary.& when a worker present only 30 days ,he gets 100/- & if he present below 30days he gets nothing.
when I use =if(a2=31,"200",if(a2=30,"100","0")). this formula is working but problem is when i get increment it is not being sum the column of =sum(b2:b4) it shows 0.
plz help me to short out this sum problem.
thanks & best regards
varun
[email protected]
Bookmarks