Excel Macro
Closed
Joey
-
Nov 15, 2011 at 12:21 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 22, 2011 at 09:05 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 22, 2011 at 09:05 AM
Hello,
I'm trying to create a formula if I input an age range ex. 17-24 in one column then write a price, if another age range is entered ex. 25-29 then write another price. How do I accomplish this.
Thanks
I'm trying to create a formula if I input an age range ex. 17-24 in one column then write a price, if another age range is entered ex. 25-29 then write another price. How do I accomplish this.
Thanks
Related:
- Excel Macro
- Excel mod apk for pc - Download - Spreadsheets
- Spell number in excel without macro - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Excel marksheet - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 22, 2011 at 09:05 AM
Nov 22, 2011 at 09:05 AM
Hi Joey,
You mean like:
=IF(A1="17-24","14 dollar",IF(A1="25-29","18 dollar",""))
Best regards,
Trowa
You mean like:
=IF(A1="17-24","14 dollar",IF(A1="25-29","18 dollar",""))
Best regards,
Trowa