Hello,

Some people have this habit ; it’s useless.

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Jenie
Envoyé : mercredi 23 février 2011 20:38
À : excel-macros@googlegroups.com
Objet : RE: $$Excel-Macros$$ Macro Help - Please!

 

Hello excel experts, what is the importance of using + in formula as shown
below? I the plus sign, still the formula worked correct!!!

=+IF(A5="VP","Pass",IF(A5="Step","Complete",""))

=IF(A5="VP","Pass",IF(A5="Step","Complete",""))

 

Thanks

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rohan Young
Sent: Wednesday, February 23, 2011 8:15 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro Help - Please!

 

HI Kamal, 

 

Please see the attachment if it helps,

 

 

Regards

 

ROHAN

On Tue, Feb 22, 2011 at 6:33 PM, NOORAIN ANSARI <noorain.ans...@gmail.com>
wrote:

Dear Kamal,

 

Please see attached sheet..if it help..

On Mon, Feb 21, 2011 at 11:25 PM, kamal shah <kamal...@gmail.com> wrote:

Hello Excel Gurus,

 

Need small favour from experts, 

I have two columns in Excel, I need a macro, where if Column A contains
value as "Step", column B should populate "Complete".

If column A contains VP, Column B should populate "Pass".

 

 


Step


Complete

 


VP

Pass


Step

Complete


VP

Pass


VP

Pass


Step

Complete


VP

Not Run


Step

Not Run


VP

Not Run


VP

Not Run


Step

Not Run


VP

Not Run

 

Your help is highy appreciated.

 

 

cheers

Kamal

-- 
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
<http://www.excel-macros.blogspot.com/> 
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/> 
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<http://exceldailytip.blogspot.com/> 

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




-- 

Thanks & regards,

Noorain Ansari

 

-- 
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

 

-- 
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Reply via email to