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
Remove* * from formula ...for number value
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
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
=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 noorain.ans...@gmail.comwrote:
Dear Savla,
Please try it
**
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Hi Team,
Request you to
Dear Savla,
Please try it
**
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
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
Thanks Prafull and Noorain sir.
On Wed, Sep 4, 2013 at 2:33 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Remove* * from formula ...for number value
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Hi Team,
Request you to kindly provide me solution to
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.
I am trying to get sum of data range B2
.
** **
** **
* *
*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:26 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Need help
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 savla.kaus...@gmail.comwrote:
Thanks Prafull and Noorain sir.
On Wed, Sep 4, 2013 at 2:33 PM, Prafull
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 in cell B8. Answer which I am
getting