Screen Shot 2017-01-27 at 11.32.42.png

I know this is probably a basic question so bear with me.... I'm in the process of creating my first ever dashboard so may be on here a lot!

I need to create an IF formula that will ascertain if the contents of a cell begin with / and if not then multiply by a value that I will have to input manually for each line (there's only 66,000 rows in my sheet )

So in cell I2 I need a formula that gives, if A2 begins with / then give me the value in G2, if not then multiply by value.

My client is a manufacturer of pies and pasties - their products are sold in boxes normally. The dashboard I'm creating needs to have a value for number of individual products, not number of boxes. Their individual product codes are prefixed with / and their boxes are not hence the question.

I hope you guys can help me
Thanks
Clare