Search for two texts and return two times another cell if present and return 1 times

[josygeorge000]

Hi if anyone can help me on this, thanks a lot.

All I want is search for two texts and return two times another cell if present and return 1 times.

See my attached screenshot of formula. It says an error, though I am able to search for one text.

[josygeorge000]

All I am doing is search for "DGPO" or "Double" in B column and return two times the quantity if those texts are present. If not one times. But it says error after I insert or into the formula. Since the search for one text search works fine for me.

[David A Coop]

Hi there Josy - welcome to the forum.

For future reference, it is a lot easier if you attach a workbook rather than an image (per the yellow box at the top of the screen).

Having said that, and assuming that "Double" is at the beginning of the "Fixture", you could try:
=IF(OR(B71="GDPO",LEFT(B71,6)="Double"),C71*2,C71)

I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[josygeorge000]

No this does not solve the problem.

[David A Coop]

Sorry, I mistyped the GDPO - it should have been DGPO.

[David A Coop]

Please attach a workbook - it will be easier to if I can test the formula and send it back.

[josygeorge000]

It does not multiply by 2.

[David A Coop]

I see the problem - your data does not begin with the text you are looking for.

This is the problem of trying to work from a picture rather than a workbook.

I'll have to look at it tomorrow I'm sorry - I have to shut down now.

[David A Coop]

Good morning josygeorge000

Please try this
=IF(SUMPRODUCT(--ISNUMBER(SEARCH({"DGPO","Double"},B71))),C71*2,C71)

I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[David A Coop]

Thanks for the Rep and acknowledgement of success.


Regards,

David