Re: $$Excel-Macros$$ Need Help in IF formula

2018-02-14 Thread Rabindra Thapa
*Regards,* *For quick responds click here for Message * On Mon, Feb 12, 2018 at 9:31 AM, Ruchin Gupta wrote: > I have a table where data changes continously (stock market data). I want > to apply IF formula. please understand with given

$$Excel-Macros$$ Need Help in IF formula

2018-02-11 Thread Ruchin Gupta
I have a table where data changes continously (stock market data). I want to apply IF formula. please understand with given example. A1 = 10 B1 = 20 C1 = 5 D1 = where i want to put formula. Now the value of A1 keeps changing. I want that if A1>B1, it shld write "Buy" in D1 cell. Similarly if

$$Excel-Macros$$ Need help on Arrey Formula

2016-12-01 Thread Deepak Rawat
Hi, I need to calculate final billing product of several product with respective MRP. sample file is attached. Regards, Deepak -- 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 @

$$Excel-Macros$$ Need help with excel formula !!!

2016-07-17 Thread Indrajit $nai
Hello Team, Can someone assist me with the excel formula based on the criteria from B44 to B50, PFA the excel file. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of

Re: $$Excel-Macros$$ Need help for Hardest formula solution

2012-09-20 Thread dguillett1
-Macros$$ Need help for Hardest formula solution Hi All Champs, Anybody help me regarding tup formula solution. Q: I want to see Sector wise promotor,FII so on (From Dec04-Jun05) in one shot.When I click sector then Click promoter then show all promotor (From Dec04-Jun05) so on.And also same

$$Excel-Macros$$ Need help on a formula

2012-08-19 Thread hemant shah
Dear Experts, I am stuck up which my work in an excel. I need a help on a formula in the attached sheet. I have given a complete details explanation in the attached sheet. Need your help to come out of this situation. For any question or details please revert back. Thanks in advance.

Re: $$Excel-Macros$$ Need help with offset formula for VBA code

2012-03-30 Thread NOORAIN ANSARI
Dear Lucky Can you share sample sheet with complete explanation. -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Fri, Mar 30, 2012 at 5:30 PM, Zibraan lucky60...@gmail.com wrote: * * *Hi Team,* *

Re: $$Excel-Macros$$ Need help with offset formula for VBA code

2012-03-30 Thread dguillett1
@googlegroups.com Subject: $$Excel-Macros$$ Need help with offset formula for VBA code Hi Team, Need your urgent need with the below mentioned VBA code I'm looking to incorporate offset formula in the below VBA code wherever the range is given so i can just use the shortcut to format the next sheet which

Re: $$Excel-Macros$$ Need help with forecast formula

2011-09-26 Thread SFG
It looks like you are forecasting daily ship $ correctly. Is the problem in summing up the total for the month or in showing cumulative totals in your month-to-date (column L)? If the latter is the case, you can simply use an if function to grab from column M when column E has a null value.

Re: $$Excel-Macros$$ Need help with forecast formula

2011-09-25 Thread Sam Mathai Chacko
Try =FORECAST(O8,$E$6:E7,$O$6:O7) in M8 and drag down HTH, Sam Mathai Chacko (GL) On Sun, Sep 25, 2011 at 11:12 PM, Steve Weaver steveweave...@comcast.netwrote: Each day I update the attached spreadsheet with with our previous days shipments. I would like to use the daily ship data to

Re: $$Excel-Macros$$ Need help with forecast formula

2011-09-25 Thread Steve Weaver
Thank you Sam for your suggestion but I still can't get the formula to work. In case it makes a difference, I'm using Excel 2002 with SP3 installed. What am I missing? Steve On 9/25/2011 2:48 PM, Sam Mathai Chacko wrote: Try =FORECAST(O8,$E$6:E7,$O$6:O7) in M8 and drag down HTH, Sam

RE: $$Excel-Macros$$ Need help with a formula

2010-08-20 Thread Rebecca.Mathers
) The formulas are array, so they're entered with Shift+Ctrl+Enter, which automatically puts in the curley brackets and makes them work properly. Regards - Dave. Subject: RE: $$Excel-Macros$$ Need help with a formula Date: Thu, 19 Aug 2010 21:40:38 -0400 From: rebecca.math...@kraft.com To: excel

Re: $$Excel-Macros$$ Need help with a formula

2010-08-19 Thread Kishan Reddy, K
...@hotmail.com wrote: Hi Becky, If XL has put NA in a cell, you must already have a formula there. You'll need to send a sample workbook so we can see get the whole picture. Regards - Dave. Date: Wed, 18 Aug 2010 12:15:30 -0700 Subject: $$Excel-Macros$$ Need help with a formula From

RE: $$Excel-Macros$$ Need help with a formula

2010-08-19 Thread Rebecca.Mathers
-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need help with a formula Hi Becky, If XL has put NA in a cell, you must already have a formula there. You'll need to send a sample workbook so we can see get the whole picture. Regards - Dave. Date: Wed, 18 Aug 2010 12:15:30 -0700 Subject

Re: $$Excel-Macros$$ Need help with a formula

2010-08-19 Thread Michael Hayes
-Macros$$ Need help with a formula Hi Becky, If XL has put NA in a cell, you must already have a formula there. You'll need to send a sample workbook so we can see get the whole picture. Regards - Dave. Date: Wed, 18 Aug 2010 12:15:30 -0700 Subject: $$Excel-Macros$$ Need help with a formula

RE: $$Excel-Macros$$ Need help with a formula

2010-08-19 Thread Rebecca.Mathers
Thanks, Michael! -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Michael Hayes Sent: Thursday, August 19, 2010 2:37 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Need help with a formula Beckie or is it Becky

$$Excel-Macros$$ Need help with a formula

2010-08-18 Thread Beckie
I am trying to create a formula: For a given range which most values are NA, I want the cell to return the value of the cell that is above the first cell that contains value 0 (not NA). -- -- Some important links for

RE: $$Excel-Macros$$ Need help with a formula

2010-08-18 Thread Dave Bonallack
Hi Becky, If XL has put NA in a cell, you must already have a formula there. You'll need to send a sample workbook so we can see get the whole picture. Regards - Dave. Date: Wed, 18 Aug 2010 12:15:30 -0700 Subject: $$Excel-Macros$$ Need help with a formula From: rebecca.math...@kraft.com