If statement help required.
Good morning,
I'm a looking for a formula to complete the following;
If cell f3 contains the letters 'sjk' then return the data from cell f3, if the data in f3 does not contain 'sjk' then return data from cell a1.
Sorry to be a nuisance, any hell will be greatly appreciated.
Thank you in advance
If cell F3 contains sjk then it can not contain date. What do you want to return?
Data, a1 contains serial no.s.
F3 also contains serial numbers majority of which contain 'sjk'.
I require f4 which is blank to return data from a1 if data in f3 doesn't contain 'sjk'
Thank you in advance
Hi Sanj,
I think Zbor has misread your posting. You said data not date.
Taking you literally, in any other cell you could put =IF(F3="SJK",F3,A1)
Or is it more complicated than that?
Russell
Please upload your workbook
Last edited by Russell Dawson; 05-05-2012 at 07:05 AM. Reason: Posted before seeing posting 3.
If I helped, please don't forget to add to my reputation. (click on the star below the post)
If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.
Failure is not falling down but refusing to get up.
ah, data...
Try: =IF(ISNUMBER(FIND("sjk",F3)), F3, A1)
Try
=IF(ISNUMBER(SEARCH("*SJK*",F3)),"SJK",A1)
Too late!!
Last edited by Russell Dawson; 05-05-2012 at 07:09 AM. Reason: Just too late again!
F3=aaa:sjk122
The formula may need to search for 'sjk' within field for it to work correctly. I think. Any suggestions?
Lol. Glad someone's on the ball.
That worked perfectly, thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks