ExcelBanter - If Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If Question (https://www.excelbanter.com/excel-worksheet-functions/105428-if-question.html)

Carl

If Question

How do I put this into an excel formula ?

If this "MID(N3;6;3)" equals "OLA" then do this "MID(N3;6;3)&LEFT(N3;3)"

otherwise

Y3&MID(N3;6;3)

Thank you in advance.

tim m

If Question

Can't really check this without knowing what your data looks like but see if
this works.

=IF(MID(N3,6,3)="OLA",MID(N3,6,3)&LEFT(N3,3),Y3&MI D(N3,6,3))

"carl" wrote:

How do I put this into an excel formula ?

If this "MID(N3;6;3)" equals "OLA" then do this "MID(N3;6;3)&LEFT(N3;3)"

otherwise

Y3&MID(N3;6;3)

Thank you in advance.

Toppers

If Question

=IF(MID(N3;6;3)="OLA",MID(N3;6;3)&LEFT(N3;3),Y3&MI D(N3;6;3))

"carl" wrote:

How do I put this into an excel formula ?

If this "MID(N3;6;3)" equals "OLA" then do this "MID(N3;6;3)&LEFT(N3;3)"

otherwise

Y3&MID(N3;6;3)

Thank you in advance.

All times are GMT +1. The time now is 06:40 AM.