Excel Help

Closed
dazza - Aug 31, 2010 at 05:49 AM
 Dazza - Aug 31, 2010 at 10:18 AM
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
Related:

1 response

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
0
This works PERFECTLY. Very many thanks!
0