How do i use a macro to do this? [Closed]

Report
-
Posts
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
-
Hello,

I am trying to set up a macro to use in a program where for example. If a value of 1 or 1st place then the value of 6 would be appointed to that cell and if 2 then the value of 4 and so forth. Please help.




1 reply

Posts
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
462
Hi macro-ed out,

Try this:
=IF(A1=1,6,IF(A1=2,4,IF(A1=3, and so forth ,"")))

Since you didn't specify the rest, I can't give full formula.

Usually a macro is used when formula's can't get the job done.

Does this work for you?

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!