26 PM
To: excel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com>
Subject: $$Excel-Macros$$ Need help on silly problem quickly
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
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:
>
e like “-1”, “1”. Simply right -1, 1.
>
> ** **
>
> ** **
>
> * *
>
> *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
o:excel-macros@googlegroups.com]
On Behalf Of KAUSHIK SAVLA
Sent: Wednesday, September 04, 2013 2:26 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help on silly problem quickly
Hi Team,
Request you to kindly provide me solution to below silly problem I am facing
in excel.
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
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, seems some problem with formatting.
Pls help.
--
*Warm Regards,*
*Kaushik Savla*
--
Are you =EXP(
