Excel Help [Closed]

Report
-
 Dazza -
Hello,



I am using a spreadsheet where column A will have as part of the cell text string L3 or L4. I need a formula elsewhere on the spreadsheet whereupon if the cell in the column contains L3 it will put 00:45 in another cell but if the cell in the column contains L4 it will put 01:00. I need help with correct formula.

In my own words,
If cells A1:A50 contain text string L3 type 00:45 in this cell but if the text string L4 appears type 01:00 instead.

Hope someone can help.

Many thanks

1 reply

Hi Dazza,

Put the following formula in B1 or any other cell:
=IF(ISERROR(SEARCH("L3",A1)),IF(ISERROR(SEARCH("L4",A1)),"","01:00"),"00:45")
Now drag it down.

Did I understood you correctly?

Best regards,
Trowa
This works PERFECTLY. Very many thanks!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!