If/then with case statement

**nhi** · 05-28-2013, 05:44 PM

Attached Excel Sheet.

If record 2 (B Column minus header) contains zero, put the value "ZZ"; however if the value is greather than zero go to Record 1 (Column A) to determine the value in the case statment and populate the value in Record 3 (Column C)

Highlighted in yellow are the correct answers.

Thank you.

**tehneXus** · 05-28-2013, 05:59 PM

formula for C2:

Please Login or Register  to view this content.

**nhi** · 05-28-2013, 06:18 PM

Thanks, however I need a VBA formulation.

**tehneXus** · 05-29-2013, 05:22 AM

As a loop for the data in the sample:

Please Login or Register  to view this content.

**nhi** · 05-29-2013, 11:38 AM

Is there anyone to make the program dynamic with ranges, whereas lets say the range of Record 1 (Column A) is changing. ( For i = 2 to n?)

**tehneXus** · 05-29-2013, 11:45 AM

Please Login or Register  to view this content.

till last row of data in column A

If/then with case statement

LinkBack

Thread Tools

Rate This Thread

Display

If/then with case statement

Re: If/then with case statement

Re: If/then with case statement

Re: If/then with case statement

Re: If/then with case statement

Re: If/then with case statement

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions