RE: FW: $$Excel-Macros$$ Dynamic KM Difference Formula

2013-05-25 Thread Amit Desai (MERU)
YES... this helped me a lot.. Thanks a lot. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of priti verma Sent: 25 May 2013 16:13 To: excel-macros@googlegroups.com Subject: Re: FW: $$Excel-Macros$$ Dynamic KM Difference Formula Hi Amit sir, Please use this

Re: FW: $$Excel-Macros$$ Dynamic KM Difference Formula

2013-05-25 Thread priti verma
Hi Amit sir, Please use this formula,if it helps =ABS(IF(IF(AND(H2="yes",G3="no"),AND(H2="yes",G4="yes"))=TRUE,D2-D4,0)-IF(AND(H2="yes",G3="yes"),D2-D3,0)) On Sat, May 25, 2013 at 3:24 PM, Amit Desai (MERU) wrote: > Can someone please look at my query & help me? > > ** ** > > *From:* excel-

Re: FW: $$Excel-Macros$$ Dynamic KM Difference Formula

2013-05-25 Thread Vabz
groups.com > *Cc:* Amit Desai (MERU) > *Subject:* Re: FW: $$Excel-Macros$$ Dynamic KM Difference Formula > > > > PFA > > > > Just Drag & Drop first formula!! > > > > Cheers!! > > On Saturday, May 25, 2013 3:24:08 PM UTC+5:30,

RE: FW: $$Excel-Macros$$ Dynamic KM Difference Formula

2013-05-25 Thread Amit Desai (MERU)
No its not that easy. From: Vabz [mailto:v...@vabs.in] Sent: 25 May 2013 15:51 To: excel-macros@googlegroups.com Cc: Amit Desai (MERU) Subject: Re: FW: $$Excel-Macros$$ Dynamic KM Difference Formula PFA Just Drag & Drop first formula!! Cheers!! On Saturday, May 25, 2013 3:24:08 PM UTC+

Re: FW: $$Excel-Macros$$ Dynamic KM Difference Formula

2013-05-25 Thread Vabz
PFA Just Drag & Drop first formula!! Cheers!! On Saturday, May 25, 2013 3:24:08 PM UTC+5:30, Amit Desai (MERU) wrote: > > Can someone please look at my query & help me? > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Amit Desai (MERU) > *Se