I am trying to sell tickets and users have a choice of 5 tickets for $5, 10 for $10 and 25 for $20, and I cannot figure out a formula for the drop down choice that will show the right total in the next column
Thanks to anyone for helping
I am trying to sell tickets and users have a choice of 5 tickets for $5, 10 for $10 and 25 for $20, and I cannot figure out a formula for the drop down choice that will show the right total in the next column
Thanks to anyone for helping
=LOOKUP(A1,{5,10,25},{5,10,20})
where A1 is the number of tickets
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
G is Raffle tickets H is total
On the dropdown for Column G, a person chooses 5, 10 or 25 tickets, Column H is the total based on what is entered in G, et. al 5 is chosen G,, then H shows $5, 10 in G, H shows $10, 25 in G, H shows $20. .
Sorry if I was not clearer.
Thanks
Replace A1 in my formula with the cell in column G
Tried it, did not work.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks