$$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread KAUSHIK SAVLA
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

Re: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread Prafull Jadhav
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

Re: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread NOORAIN ANSARI
=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

Re: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread NOORAIN ANSARI
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

Re: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread KAUSHIK SAVLA
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

RE: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread Ravi Kumar
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

Re: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread KAUSHIK SAVLA
. ** ** ** ** * * *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

Re: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread Waseem Saifi
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

RE: $$Excel-Macros$$ Need help on silly problem quickly

2013-09-04 Thread Ravi Kumar
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