$$Excel-Macros$$ What does this formula do?

Hi All, Please help me out on this formula. I would require an expanation for each action taken by formula. =IF(($J$16-ROW())*10+11*(IF($H$16="R",0,1)) + (-1)^(IF($H$16="R",0,1))*(($L$16-COLUMN())+1)<=$D$16,1,"") Attached is the file for r

Re: $$Excel-Macros$$ What does this formula do?

this. Regards SACHIN OR On Wed, May 19, 2010 at 10:56 PM, Paul Schreiner wrote: > It would be helpful if we had some sample data for row 16, but I'll do > what i can > There are contents in row 16, > columns D, H, J and L > > the overall action is that there is a ca

$$Excel-Macros$$ Prepare break database(HTML)

terface will be able to see my break diffrence at realtime. This process can be followed by 40 other user at the sametime. Requirement of this report is on priority HTML preferablly or access. Please help me with this... Its urgent requirement. Regards Sachin OR --

Re: $$Excel-Macros$$ Prepare break database(HTML)

Hi all, Please could you help me prepare this?? Regards Sachin O.R Sent from BlackBerry® on Airtel -Original Message- From: sachin or Sender: excel-macros@googlegroups.com Date: Sun, 18 Jul 2010 01:44:29 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Prepare