Excel Macro

Closed
Joey - 15 Nov 2011 à 12:21
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 22 Nov 2011 à 09:05
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


Related:

1 response

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
22 Nov 2011 à 09:05
Hi Joey,

You mean like:
=IF(A1="17-24","14 dollar",IF(A1="25-29","18 dollar",""))

Best regards,
Trowa