IF functions need to be used. The IF statement needs to show what the ticket type is and how much it is. Please use cell referencing with the assumptions. Don't understand how to set it up correctly, please show the function.

. B C D E F 1 1 2 3 First Name Age Ticket Price Ticket Type 10 Jon 4 Ticket Calculator 5 Last Name 6 Smith 7 Reed 8 Johnson 9 Peterson 10 Jefferson 17 Tony Ray Tom 32 2 Tim 2 11 12 Assumptions 13 Child 14 3 $ 10 15 Age cutoff Price Age cutoff Price Price 16 Student 16 15 $ $ 17 Adult 20 18