Excel Database

Hi Everyone,

This is my first post and i really need some serious help here. I am in the ticketing sales industry and i need to create a database to tabulate tickets sold and redeemed.

A B C D E

Cell Transaction Type Quantity Tier1 Balance
B1 Purchase 300 1 100
B2 Redeem 1 1 101
B3 Purchase 100 2 100
B4 Redeem 2 2 98


What i want to do is that : If B2 is purchase, then it will automatically add up | B1 is Redeem then it will be subtract as shown.. However, I have a Tier System here.

I have tickets of 2 different timing.Tier 1 = Morning Tier 2 = Evening.

Tour Agency will buy tickets of 2 different time. T1 / T2 and i need to keep track of the tickets sold / Redeem / Balance

Can anyone provide the formula - If B1 is purchase , tier 1, it will be a certain color, B1 if redeem will be another color of something ?

I cant figure a wayout for this formula.. please help

Welcome to the Forum, you need to read the Forum Rules & post accordingly

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

After this attach an example workbook