Excel Help

dazza - Aug 31, 2010 at 05:49 AM
 Dazza - Aug 31, 2010 at 10:18 AM

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 response

Hi Dazza,

Put the following formula in B1 or any other cell:
Now drag it down.

Did I understood you correctly?

Best regards,
This works PERFECTLY. Very many thanks!