Previous Topic Next Topic

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
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

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses