IF with a LEFT search

[pook_666]

Hello magicians!

I need help with something probably really basic that I can't get my head around.

I need a formula that searches for the first two numbers in a cell, and if it matches to another, produce a multiplication formula.

For example of what I am trying to get, I have the below where I want a formula in column C where if any of the cells in column A begin with "25", I want to multiply column B by cell F1. If column A doesn't begin with "25" I want to just leave it with what is in column B....so I want to go from this:

To this:

Believe there is some form of IF, LEFT, FIND formula I can use, but just can't figure it out?

Thanks for the help!

 

[Silverhorne]

=IF(LEFT(A2,2)="25",B2*$F$1,B2)

Paste into C2 and pull down.

 

[pook_666]

Perfect - thank you!

 

[smozgur]

Perfect - thank you!

Hi @pook_666. Glad to hear that you received an answer which solved your question quickly!

While you are still around, would you consider clicking on the little checkmark right next to the answer post that @Silverhome provided above, so everybody else knows that this question has a solution?
In fact, it would be also great if you could visit the following link to see your old questions, and also mark the solutions for the ones you also had an answer like this one.

Excel Questions

All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. Do not post questions about other spreadsheet programs (e.g. Google Sheets) in this forum.

www.mrexcel.com

Thank you for the feedback!

 

[pook_666]

@smozgur - done! Will remember for next time!

 

[smozgur]

done! Will remember for next time!