How do i use a macro to do this?
Closed
macro-ed out
-
17 Sep 2011 à 20:07
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 19 Sep 2011 à 08:22
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 19 Sep 2011 à 08:22
Related:
- How do i use a macro to do this?
- How to run a macro in excel - Guide
- Run Macros in Excel: online, shortcuts, VBA - Guide
- How to copy macro from one workbook to another - Guide
- Macro for number to words in excel - Guide
- Convert multiple rows to columns in excel macro - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
19 Sep 2011 à 08:22
19 Sep 2011 à 08:22
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
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
