Re: $$Excel-Macros$$ help on if formula

2015-05-19 Thread Abhishek Jain
=IF(C5<0,0,IF(C5>380,C5-B5,IF(AND(D5>0,D5<=380),C5,"NA"))) Drag down... On Wed, May 20, 2015 at 11:22 AM, ankit sharma wrote: > Dear Experts i want a formula that fulfill my both conditions pls solve > this. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =T

$$Excel-Macros$$ help on if formula

2015-05-19 Thread ankit sharma
Dear Experts i want a formula that fulfill my both conditions pls solve this. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accura

$$Excel-Macros$$ Query on Extract word

2015-05-19 Thread Kal xcel
Dear Experts, Please help. Query is in the attached sheet. -- *Kalyan Chattopadhyay* *Executive Corporate MIS* *Joy Cosmetics* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.faceboo

$$Excel-Macros$$ Looking for Excel VBA macro to export CSV or TAB-delimited with "linefeed" character ...

2015-05-19 Thread Greg
Hi, FYI, I have an Excel spreadsheet that contains the linefeed (ALT-Enter) character inside of a couple of cells. However, I wish to export this character into a CSV or TAB-delimited file. Whenever I use the Excel SaveAs command to export either format, the results "appear to be" hard return

Re: $$Excel-Macros$$ Need to merge excel files whilkt maintaining their links to a Powerpoint file

2015-05-19 Thread Paul Schreiner
why would it break the links?If you have the Powerpoint open at the time you're combining the Excel files, it shouldn't break the links. Do you actually mean that the Powerpoint has links to the Excel files?(rather than the Excel having links to the PowerPoint)It would then be understandable tha

$$Excel-Macros$$ Need to merge excel files whilkt maintaining their links to a Powerpoint file

2015-05-19 Thread David Stubbs
Hello, I have several excel files with active links to a PowerPoint file. I need to combine the Excels into one, but any way i try to do so breaks the links. Is there a way to combine the files whilst maintaining the links? Thanks in advance David -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

$$Excel-Macros$$ Split Data Query

2015-05-19 Thread Ashish Bhalara
Hello experts, I want to split selection data to next columns by macro, please see attached file for require output. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- Are you =EXP(E:RT) or =NOT(EXP(