Dear GRKNAIDU,
Please use this formula in the Bonus Qty column and copy down:
=IF(MOD(J4,100)=0,(J4/100)*20,ROUNDDOWN(J4/100,0)*20)
Regards,
Aindril
On Sat, Mar 2, 2013 at 5:33 PM, GRKRISHNA NAIDU grnaidu1...@gmail.comwrote:
Dear all
Will you please help to get the formula
for an
Hi,
Try it,
=TRIM(RIGHT(SUBSTITUTE(A1, ,REPT(
,100)),100))=TRIM(RIGHT(SUBSTITUTE(B1, ,REPT( ,100)),100))
On Sat, Mar 2, 2013 at 11:46 AM, satyas manav...@gmail.com wrote:
Hi Nitin,
I found an error when I applied it on my database where there is no space
between last name and first name.
Hello
I have attached file
http://www.sendspace.com/file/wjh0oe
I want to automated a some step (tab table Z)
Thus, for example, that in X 2012:
1) I want to copy D16:E16
2) added a new one blank below before the paste D17:E17
3) converted the 2011 to 2012 in cells D17: E17 (ctr+h function