Previous Topic Next Topic

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

Answer 1 / 1
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
Ask a question