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 Moderator Last seen December 27, 2022 - Sep 19, 2011 at 08:22 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 19, 2011 at 08:22 AM
Related:
- How do i use a macro to do this?
- Spell number in excel without macro - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Macro excel download - Download - Spreadsheets
- Run macro on opening workbook - Guide
- Excel vba assign macro to button programmatically - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
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