Solved If statements

October 20, 2011 at 08:56:16
Specs: Windows XP
I want to perform an if statement that says If A1=1, then A2=8, if A1=2, then A2=16, if A1=3, then A2=24, If A1=8, then A2=64, if A1=12, then A2=96

A1 is a drop down box with options 0-15


See More: If statements

Report •


#1
October 20, 2011 at 09:07:44
✔ Best Answer
Why do you need an IF?

Why not just use this?

=A1*8

or are you only concerned with the 5 specific values you mentioned (1, 2, 3, 8, 12)?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
October 20, 2011 at 09:19:15
thanks, I CAN use =A1*8

Report •

#3
October 24, 2011 at 07:40:29
DerbyDad03, can you help me with this macro

Im trying to copy some old code from a macro., what does this macro mean in English?
Selection.AutoFilter Field:=9, Criteria1:="Yes"

criteria1= automotive


Report •

Related Solutions

#4
October 24, 2011 at 08:16:37
I see that you have posted this macro related question in a separate thread.

That is the correct process for this forum.

You should not mix unrelated questions in a given thread.

Please wait for an answer in the thread directly realted to your macro question.

DerbyDad03
Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •


Ask Question