• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Convert cell value using If statement

D

dububer

New Member
Hello can someone help me how can I convert a cell value using If statement in VBA? In column A contain numbers and I want to convert them using this formula. I will just run the macro and the whole data in column A will turn to this ="IF(AND(B4<12,B4>-1),"<12",IF(AND(B4>12,B4<24),"12-24",IF(AND(B4>24,B4<36),"24-36",IF(AND(B4>36,B4<48),"36-48","48+"))))"
 
dububer
As a new member, You should reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
especially How to get the Best Results at Chandoo.org have many useful sentences which You seems to missed.

... You wrote that You have numbers in A-column ... okay
... You wrote about some formula which refers to B-column ... okay
... what would be in B-column?
Many things would be more clear ... after You have reread Forum Rules and continue after that.
 
You must log in or register to reply here.
Back
Top