Welcome friend
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of KAUSHIK SAVLA
Sent: Wednesday, September 04, 2013 2:40 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help on silly problem
Dear Kaushik,
No need to close numbers in double quotes.
just simply type numbers as numbers, like Type 1 instead of "1" or -1
instead of "-1"
On Wed, Sep 4, 2013 at 2:37 PM, KAUSHIK SAVLA wrote:
> Thanks Prafull and Noorain sir.
>
>
> On Wed, Sep 4, 2013 at 2:33 PM, Prafull Jadhav
> wrote:
>
Thanks Ravi!
On Wed, Sep 4, 2013 at 2:38 PM, Ravi Kumar wrote:
> Hi,
>
> ** **
>
> ** **
>
> Here is ur solution
>
> ** **
>
> Don’t use “1” when u put number in if condition always give numbers as it
> is. There is no need to give like “-1”, “1”. Simply right -1, 1.
>
> ** **
>
> *
Hi,
Here is ur solution
Don't use "1" when u put number in if condition always give numbers as it
is. There is no need to give like "-1", "1". Simply right -1, 1.
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf
Thanks Prafull and Noorain sir.
On Wed, Sep 4, 2013 at 2:33 PM, Prafull Jadhav wrote:
>
> Remove* "" * from formula ...for number value
>
>
> On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA wrote:
>
>> Hi Team,
>>
>> Request you to kindly provide me solution to below silly problem I am
>> facing i
=IF(A2=9,N(1),IF(A2=10,N(1),IF(A2<=6,N(-1),IF(A2=N(7),"",IF(A2=N(8),"")
On Wed, Sep 4, 2013 at 2:37 PM, NOORAIN ANSARI wrote:
> Dear Savla,
>
> Please try it
>
> **
>
>
> On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA wrote:
>
>> Hi Team,
>>
>> Request you to kindly provide me solution to bel
Dear Savla,
Please try it
**
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA wrote:
> Hi Team,
>
> Request you to kindly provide me solution to below silly problem I am
> facing in excel.
>
> I am trying to get sum of data range B2 to B6 in cell B8. Answer which I
> am getting is not correct, se
Remove* "" * from formula ...for number value
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA wrote:
> Hi Team,
>
> Request you to kindly provide me solution to below silly problem I am
> facing in excel.
>
> I am trying to get sum of data range B2 to B6 in cell B8. Answer which I
> am getting is
