Formula

I’m looking to try and create a few formulas

First one being – I need to enter a competition number into a cell and each one equals a specific price.. I want the spreadsheet to calculate how many of the cells have data in them and multiply them by the amount per Dance etc.

So if a box is blank that means that there’s no charge for it, if it contains a number which will be different every time it equals £3 for example..
By: Hollie

Leave a Reply

Your email address will not be published. Required fields are marked *