Re: $$Excel-Macros$$ Need Urgent Help on If statement

2012-07-18 Thread ponnusamy paramasivan
On 7/4/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
 Dear Mangesh,

 Please put it in Module after press Alt+F11.
 Then we can use it under Activeworkbook.


 On Wed, Jul 4, 2012 at 8:06 PM, Mangesh Vimay
 mangesh.da...@gmail.comwrote:

 Thanks Noorain Where should I put this code. I mean in module or any
 the place to run the code.
 Please tell me detail as u know very well I am new to VBA.

 On 7/4/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
  Dear Mangesh,
 
  Please use it
 
  *Function Test(rng As Excel.Range)
  If rng.Value   And rng.Value = 24 Then
  Test = 24 Hours
  ElseIf rng.Value   And rng.Value  24 Then
  Test = 24 Hours
  Else
  Test = 
  End If
  End Function
  *
 
  On Wed, Jul 4, 2012 at 7:52 PM, Mangesh Vimay
  mangesh.da...@gmail.comwrote:
 
  Hi Friends/Ashish,
 
  How will you put this formula in vba code. please tell.
 
  On 7/4/12, Mangesh Vimay mangesh.da...@gmail.com wrote:
   Thank you so much mere bhai u saved my job 
  
   On 7/4/12, ashish koul koul.ash...@gmail.com wrote:
   = iF(ISBLANK(A2),,IF(A2=24,24 Hours,24 Hours))
  
  
  
   On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay
   mangesh.da...@gmail.comwrote:
  
   Hi Friends,
  
   Please find the attached sheet for if statement.
   Please help me dear all !!!
  
   --
   With regards,
  
   MaNgEsH
  
   --
   FORUM RULES (986+ members already BANNED for violation)
  
   1) Use concise, accurate thread titles. Poor thread titles, like
   Please
   Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
   Advice
   will not get quick attention or may not be answered.
  
   2) Don't post a question in the thread of another member.
  
   3) Don't post questions regarding breaking or bypassing any
   security
   measure.
  
   4) Acknowledge the responses you receive, good or bad.
  
   5)  Cross-promotion of, or links to, forums competitive to this
 forum
  in
   signatures are prohibited.
  
   NOTE  : Don't ever post personal or confidential data in a
   workbook.
   Forum
   owners and members are not responsible for any loss.
  
  
  
 
 --
   To post to this group, send email to excel-macros@googlegroups.com
  
   To unsubscribe, send a blank email to
   excel-macros+unsubscr...@googlegroups.com
  
  
  
  
   --
   *Regards*
   * *
   *Ashish Koul*
   *http://www.excelvbamacros.com/*
   *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/
  
  
   P Before printing, think about the environment.
  
   --
   FORUM RULES (986+ members already BANNED for violation)
  
   1) Use concise, accurate thread titles. Poor thread titles, like
   Please
   Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
   Advice
   will
   not get quick attention or may not be answered.
  
   2) Don't post a question in the thread of another member.
  
   3) Don't post questions regarding breaking or bypassing any
   security
   measure.
  
   4) Acknowledge the responses you receive, good or bad.
  
   5)  Cross-promotion of, or links to, forums competitive to this
   forum
   in
   signatures are prohibited.
  
   NOTE  : Don't ever post personal or confidential data in a
   workbook.
   Forum
   owners and members are not responsible for any loss.
  
  
 
 --
   To post to this group, send email to excel-macros@googlegroups.com
  
   To unsubscribe, send a blank email to
   excel-macros+unsubscr...@googlegroups.com
  
  
   --
   With regards,
  
   MaNgEsH
  
 
 
  --
  With regards,
 
  MaNgEsH
 
  --
  FORUM RULES (986+ members already BANNED for violation)
 
  1) Use concise, accurate thread titles. Poor thread titles, like
  Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
  Advice
  will not get quick attention or may not be answered.
 
  2) Don't post a question in the thread of another member.
 
  3) Don't post questions regarding breaking or bypassing any security
  measure.
 
  4) Acknowledge the responses you receive, good or bad.
 
  5)  Cross-promotion of, or links to, forums competitive to this forum
  in
  signatures are prohibited.
 
  NOTE  : Don't ever post personal or confidential data in a workbook.
  Forum
  owners and members are not responsible for any loss.
 
 
 
 --
  To post to this group, send email to excel-macros@googlegroups.com
 
  To unsubscribe, send a blank email to
  excel-macros+unsubscr...@googlegroups.com
 
 
 
 
  --
  Thanks  regards,
  Noorain Ansari
  www.noorainansari.com
  www.excelmacroworld.blogspot.com
 
  --
  FORUM RULES (986+ members already BANNED for violation)
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will
  not 

$$Excel-Macros$$ Need Urgent Help on If statement

2012-07-04 Thread Mangesh Vimay
Hi Friends,

Please find the attached sheet for if statement.
Please help me dear all !!!

-- 
With regards,

MaNgEsH

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Help for IF.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Re: $$Excel-Macros$$ Need Urgent Help on If statement

2012-07-04 Thread ashish koul
= iF(ISBLANK(A2),,IF(A2=24,24 Hours,24 Hours))



On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:

 Hi Friends,

 Please find the attached sheet for if statement.
 Please help me dear all !!!

 --
 With regards,

 MaNgEsH

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/* http://www.accessvbamacros.com/


P Before printing, think about the environment.

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Need Urgent Help on If statement

2012-07-04 Thread Mangesh Vimay
Thank you so much mere bhai u saved my job 

On 7/4/12, ashish koul koul.ash...@gmail.com wrote:
 = iF(ISBLANK(A2),,IF(A2=24,24 Hours,24 Hours))



 On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay
 mangesh.da...@gmail.comwrote:

 Hi Friends,

 Please find the attached sheet for if statement.
 Please help me dear all !!!

 --
 With regards,

 MaNgEsH

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook.
 Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




 --
 *Regards*
 * *
 *Ashish Koul*
 *http://www.excelvbamacros.com/*
 *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/


 P Before printing, think about the environment.

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.

 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com


-- 
With regards,

MaNgEsH

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com


Re: $$Excel-Macros$$ Need Urgent Help on If statement

2012-07-04 Thread Mangesh Vimay
Hi Friends/Ashish,

How will you put this formula in vba code. please tell.

On 7/4/12, Mangesh Vimay mangesh.da...@gmail.com wrote:
 Thank you so much mere bhai u saved my job 

 On 7/4/12, ashish koul koul.ash...@gmail.com wrote:
 = iF(ISBLANK(A2),,IF(A2=24,24 Hours,24 Hours))



 On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay
 mangesh.da...@gmail.comwrote:

 Hi Friends,

 Please find the attached sheet for if statement.
 Please help me dear all !!!

 --
 With regards,

 MaNgEsH

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook.
 Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




 --
 *Regards*
 * *
 *Ashish Koul*
 *http://www.excelvbamacros.com/*
 *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/


 P Before printing, think about the environment.

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook.
 Forum
 owners and members are not responsible for any loss.

 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com


 --
 With regards,

 MaNgEsH



-- 
With regards,

MaNgEsH

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com


Re: $$Excel-Macros$$ Need Urgent Help on If statement

2012-07-04 Thread NOORAIN ANSARI
Dear Mangesh,

Please use it

*Function Test(rng As Excel.Range)
If rng.Value   And rng.Value = 24 Then
Test = 24 Hours
ElseIf rng.Value   And rng.Value  24 Then
Test = 24 Hours
Else
Test = 
End If
End Function
*

On Wed, Jul 4, 2012 at 7:52 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:

 Hi Friends/Ashish,

 How will you put this formula in vba code. please tell.

 On 7/4/12, Mangesh Vimay mangesh.da...@gmail.com wrote:
  Thank you so much mere bhai u saved my job 
 
  On 7/4/12, ashish koul koul.ash...@gmail.com wrote:
  = iF(ISBLANK(A2),,IF(A2=24,24 Hours,24 Hours))
 
 
 
  On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay
  mangesh.da...@gmail.comwrote:
 
  Hi Friends,
 
  Please find the attached sheet for if statement.
  Please help me dear all !!!
 
  --
  With regards,
 
  MaNgEsH
 
  --
  FORUM RULES (986+ members already BANNED for violation)
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
  will not get quick attention or may not be answered.
 
  2) Don't post a question in the thread of another member.
 
  3) Don't post questions regarding breaking or bypassing any security
  measure.
 
  4) Acknowledge the responses you receive, good or bad.
 
  5)  Cross-promotion of, or links to, forums competitive to this forum
 in
  signatures are prohibited.
 
  NOTE  : Don't ever post personal or confidential data in a workbook.
  Forum
  owners and members are not responsible for any loss.
 
 
 
 --
  To post to this group, send email to excel-macros@googlegroups.com
 
  To unsubscribe, send a blank email to
  excel-macros+unsubscr...@googlegroups.com
 
 
 
 
  --
  *Regards*
  * *
  *Ashish Koul*
  *http://www.excelvbamacros.com/*
  *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/
 
 
  P Before printing, think about the environment.
 
  --
  FORUM RULES (986+ members already BANNED for violation)
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
  will
  not get quick attention or may not be answered.
 
  2) Don't post a question in the thread of another member.
 
  3) Don't post questions regarding breaking or bypassing any security
  measure.
 
  4) Acknowledge the responses you receive, good or bad.
 
  5)  Cross-promotion of, or links to, forums competitive to this forum in
  signatures are prohibited.
 
  NOTE  : Don't ever post personal or confidential data in a workbook.
  Forum
  owners and members are not responsible for any loss.
 
 
 --
  To post to this group, send email to excel-macros@googlegroups.com
 
  To unsubscribe, send a blank email to
  excel-macros+unsubscr...@googlegroups.com
 
 
  --
  With regards,
 
  MaNgEsH
 


 --
 With regards,

 MaNgEsH

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




-- 
Thanks  regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to 

Re: $$Excel-Macros$$ Need Urgent Help on If statement

2012-07-04 Thread Mangesh Vimay
Thanks Noorain Where should I put this code. I mean in module or any
the place to run the code.
Please tell me detail as u know very well I am new to VBA.

On 7/4/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
 Dear Mangesh,

 Please use it

 *Function Test(rng As Excel.Range)
 If rng.Value   And rng.Value = 24 Then
 Test = 24 Hours
 ElseIf rng.Value   And rng.Value  24 Then
 Test = 24 Hours
 Else
 Test = 
 End If
 End Function
 *

 On Wed, Jul 4, 2012 at 7:52 PM, Mangesh Vimay
 mangesh.da...@gmail.comwrote:

 Hi Friends/Ashish,

 How will you put this formula in vba code. please tell.

 On 7/4/12, Mangesh Vimay mangesh.da...@gmail.com wrote:
  Thank you so much mere bhai u saved my job 
 
  On 7/4/12, ashish koul koul.ash...@gmail.com wrote:
  = iF(ISBLANK(A2),,IF(A2=24,24 Hours,24 Hours))
 
 
 
  On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay
  mangesh.da...@gmail.comwrote:
 
  Hi Friends,
 
  Please find the attached sheet for if statement.
  Please help me dear all !!!
 
  --
  With regards,
 
  MaNgEsH
 
  --
  FORUM RULES (986+ members already BANNED for violation)
 
  1) Use concise, accurate thread titles. Poor thread titles, like
  Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
  Advice
  will not get quick attention or may not be answered.
 
  2) Don't post a question in the thread of another member.
 
  3) Don't post questions regarding breaking or bypassing any security
  measure.
 
  4) Acknowledge the responses you receive, good or bad.
 
  5)  Cross-promotion of, or links to, forums competitive to this forum
 in
  signatures are prohibited.
 
  NOTE  : Don't ever post personal or confidential data in a workbook.
  Forum
  owners and members are not responsible for any loss.
 
 
 
 --
  To post to this group, send email to excel-macros@googlegroups.com
 
  To unsubscribe, send a blank email to
  excel-macros+unsubscr...@googlegroups.com
 
 
 
 
  --
  *Regards*
  * *
  *Ashish Koul*
  *http://www.excelvbamacros.com/*
  *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/
 
 
  P Before printing, think about the environment.
 
  --
  FORUM RULES (986+ members already BANNED for violation)
 
  1) Use concise, accurate thread titles. Poor thread titles, like
  Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
  Advice
  will
  not get quick attention or may not be answered.
 
  2) Don't post a question in the thread of another member.
 
  3) Don't post questions regarding breaking or bypassing any security
  measure.
 
  4) Acknowledge the responses you receive, good or bad.
 
  5)  Cross-promotion of, or links to, forums competitive to this forum
  in
  signatures are prohibited.
 
  NOTE  : Don't ever post personal or confidential data in a workbook.
  Forum
  owners and members are not responsible for any loss.
 
 
 --
  To post to this group, send email to excel-macros@googlegroups.com
 
  To unsubscribe, send a blank email to
  excel-macros+unsubscr...@googlegroups.com
 
 
  --
  With regards,
 
  MaNgEsH
 


 --
 With regards,

 MaNgEsH

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook.
 Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.com

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
 not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5)  Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE  : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are 

Re: $$Excel-Macros$$ Need Urgent Help on If statement

2012-07-04 Thread NOORAIN ANSARI
Dear Mangesh,

Please put it in Module after press Alt+F11.
Then we can use it under Activeworkbook.


On Wed, Jul 4, 2012 at 8:06 PM, Mangesh Vimay mangesh.da...@gmail.comwrote:

 Thanks Noorain Where should I put this code. I mean in module or any
 the place to run the code.
 Please tell me detail as u know very well I am new to VBA.

 On 7/4/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
  Dear Mangesh,
 
  Please use it
 
  *Function Test(rng As Excel.Range)
  If rng.Value   And rng.Value = 24 Then
  Test = 24 Hours
  ElseIf rng.Value   And rng.Value  24 Then
  Test = 24 Hours
  Else
  Test = 
  End If
  End Function
  *
 
  On Wed, Jul 4, 2012 at 7:52 PM, Mangesh Vimay
  mangesh.da...@gmail.comwrote:
 
  Hi Friends/Ashish,
 
  How will you put this formula in vba code. please tell.
 
  On 7/4/12, Mangesh Vimay mangesh.da...@gmail.com wrote:
   Thank you so much mere bhai u saved my job 
  
   On 7/4/12, ashish koul koul.ash...@gmail.com wrote:
   = iF(ISBLANK(A2),,IF(A2=24,24 Hours,24 Hours))
  
  
  
   On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay
   mangesh.da...@gmail.comwrote:
  
   Hi Friends,
  
   Please find the attached sheet for if statement.
   Please help me dear all !!!
  
   --
   With regards,
  
   MaNgEsH
  
   --
   FORUM RULES (986+ members already BANNED for violation)
  
   1) Use concise, accurate thread titles. Poor thread titles, like
   Please
   Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
   Advice
   will not get quick attention or may not be answered.
  
   2) Don't post a question in the thread of another member.
  
   3) Don't post questions regarding breaking or bypassing any security
   measure.
  
   4) Acknowledge the responses you receive, good or bad.
  
   5)  Cross-promotion of, or links to, forums competitive to this
 forum
  in
   signatures are prohibited.
  
   NOTE  : Don't ever post personal or confidential data in a workbook.
   Forum
   owners and members are not responsible for any loss.
  
  
  
 
 --
   To post to this group, send email to excel-macros@googlegroups.com
  
   To unsubscribe, send a blank email to
   excel-macros+unsubscr...@googlegroups.com
  
  
  
  
   --
   *Regards*
   * *
   *Ashish Koul*
   *http://www.excelvbamacros.com/*
   *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/
  
  
   P Before printing, think about the environment.
  
   --
   FORUM RULES (986+ members already BANNED for violation)
  
   1) Use concise, accurate thread titles. Poor thread titles, like
   Please
   Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
   Advice
   will
   not get quick attention or may not be answered.
  
   2) Don't post a question in the thread of another member.
  
   3) Don't post questions regarding breaking or bypassing any security
   measure.
  
   4) Acknowledge the responses you receive, good or bad.
  
   5)  Cross-promotion of, or links to, forums competitive to this forum
   in
   signatures are prohibited.
  
   NOTE  : Don't ever post personal or confidential data in a workbook.
   Forum
   owners and members are not responsible for any loss.
  
  
 
 --
   To post to this group, send email to excel-macros@googlegroups.com
  
   To unsubscribe, send a blank email to
   excel-macros+unsubscr...@googlegroups.com
  
  
   --
   With regards,
  
   MaNgEsH
  
 
 
  --
  With regards,
 
  MaNgEsH
 
  --
  FORUM RULES (986+ members already BANNED for violation)
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
  will not get quick attention or may not be answered.
 
  2) Don't post a question in the thread of another member.
 
  3) Don't post questions regarding breaking or bypassing any security
  measure.
 
  4) Acknowledge the responses you receive, good or bad.
 
  5)  Cross-promotion of, or links to, forums competitive to this forum in
  signatures are prohibited.
 
  NOTE  : Don't ever post personal or confidential data in a workbook.
  Forum
  owners and members are not responsible for any loss.
 
 
 
 --
  To post to this group, send email to excel-macros@googlegroups.com
 
  To unsubscribe, send a blank email to
  excel-macros+unsubscr...@googlegroups.com
 
 
 
 
  --
  Thanks  regards,
  Noorain Ansari
  www.noorainansari.com
  www.excelmacroworld.blogspot.com
 
  --
  FORUM RULES (986+ members already BANNED for violation)
 
  1) Use concise, accurate thread titles. Poor thread titles, like Please
  Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will
  not get quick attention or may not be answered.
 
  2) Don't post a question in the