How to create an IF formula that will determine if a cell begins with a certain character

[clareb4]

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

[Pete_UK]

You can use something like this:

=IF(LEFT(A2)="/",G2, ... )

but your requirements are vague for what you want to achieve if A2 does not begin with "/".

Hope this helps.

Pete

[Ochimus]

Clare,

If you want a "standard" manual value for cells not beginning with the oblique, put that value in X2, then put this in I2 and copy it down.

=IF(LEFT(TRIM(A2),1)="/",G2,$X$2)

If you want a different manual value for each row for cells not beginning with the oblique, put the value in Col X, then put this in I2 and copy it down.

=IF(LEFT(TRIM(A2),1)="/",G2,X2)

Hope this solves it for you

Ochimus

[clareb4]

Thank you guys

For the values not beginning with / I need G2 to be multiplied by a value returned by a VLOOKUP to another table (the quantity of pies in a box) but that part is easy and the table is already created. It was just recognising column A values starting with / that I couldn't fathom.

Sorted now - thank you!