How do i use a macro to do this?
Closed
macro-ed out
-
Sep 17, 2011 at 08:07 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Sep 19, 2011 at 08:22 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Sep 19, 2011 at 08:22 AM
Related:
- How do i use a macro to do this?
- How to run a macro in excel - Guide
- Run macro on opening: worksheet, workbook - Guide
- How to copy macro from one workbook to another - Guide
- Macro for number to words in excel - Guide
- Macro antena apk - Download - Gaming tools
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Sep 19, 2011 at 08:22 AM
Sep 19, 2011 at 08:22 AM
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