If, Then Statement With Three Choices

SOLVED


Hello,

I wanted to first thank everyone for this website and help. I have used it many times in the past to answer some questions (some common and others unique).

I had a question regarding what I think is an If-Then scenario.

Scenario:

I am working on a rather large worksheet that contains close to 20 columns of information and close to 22,000 rows. At one part I have 4 columns of data that each contain different sets of numbers.

Example:

Column 1 = 6
Column 2 = 7
Column 3 = -1
Column 4 = (blank)

Column 3 = Column 1 - Column 2. Now my problem is, for column 4, I need a certain number to autofill depending on the number in column 3.

Here are the rules:
1) If Column 3 is less than or equal to -3, I need column 4 to auto populate the number 1.
2) If Column 3 is either -2, -1, or 0, it needs to auto populate the number 3.
3) If Column 3 is greater than 0, I need it to auto populate the number 5.

If I need to provide any more information, I will be happy to help.

Thank you!

Hi Recon,

Welcome to the Forum!

Try:

Please Login or Register  to view this content.

If you haven't used macros before you'll need to go to your options - trust center -trust center settings - macro settings
, the second option down (disable all macros with notification)

Then - Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Select "Module" from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

Something like this?

Please Login or Register  to view this content.