if and formula

[louis128]

hi,what I need is a formula in L1 which will work likeif in K1 is 4 and in H:H the last two numbers are 2 1 and the third from the end is not 3 show at L1 number 3)..please see attached file!thanks!

[mrice]

Try this user defined function

Please Login or Register  to view this content.

Open the VBA editor by hitting Alt F11.
Insert a new module with Insert - Module
Paste in the above function
Go back to the sheet by hitting Alt F11.

In L1, enter =GetNumber(K1,H:H)

Remember to save the workbook as a macro enabled workbook .xlsm

[louis128]

i dont know how to use macro,but i will try.thank you!!

[louis128]

can you do it for me please?if you have time

[louis128]

dear mrice i have done it and is working! iam so good! i gust need more three additions to the formula please!

[louis128]

dear mrice is there any way that

If MyCell = 4 Then to say 4 or 3 ?

[AliGW]

Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.