Excel Macro

[Closed]
Report
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
-
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


1 reply

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
Hi Joey,

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

Best regards,
Trowa