Help with creating an Excel formula starting with a cell with text and number
Hello.
I am seeking help to create a simple formula to show ticket sales.
My starting cell has a description of the ticket category with the price of the ticket. The next cell, in the adjacent column the number of those tickets sold will be entered. I simply want to grab the number from the first cell and multiply with the number sold in a third cell. I have tried but I cant get around the text in the first cell and not an advanced user in Excel. Thank you in advance for your help.
Hello.I am seeking help to create a simple formula to show ticket sales.My starting cell has a description of the ticket category with the price of the ticket. The next cell, in the adjacent column the number of those tickets sold will be entered. I simply want to grab the number from the first cell and multiply with the number sold in a third cell. I have tried but I cant get around the text in the first cell and not an advanced user in Excel. Thank you in advance for your help. Read More