Hi all,
I am writing a equation in if statement...Is there a procedure to select the the second and third letter from a sentence and write a condition based on that...
I mean, say if I had 1XY in cell A1 and I want to write a if condition based on the XY from 1XY term, how can i do that?
Thanks in advance,
Sathish.
One way:
=IF(NOT(ISERROR(SEARCH("XY",A1,1))),"Yes","No")
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Not sure if you are doing this in VBA or a formula so:
VBA:
Formula:
Please Login or Register to view this content.
for example.Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
Thanks for quick reply,
SAy in cell A1 if I want to use any number say S53XY, S432XY or any number with XY in the last two places, is there a way to refine this code...
Thanks.
If you always want the last two:
Please Login or Register to view this content.
Hi,
I am not using VBA in this project...Is it possible write a formula...
Well, you did post in the Programming section, and your title mentions code, so...
Try this:
=IF(RIGHT(A1,2)="XY","Yes","No")
Sorry for that...
Thanks alot...it works...Have a great day...
one last question here...
say if I have S543X, 1Y , S23P and S543XY and I wrote a formula as follows
=IF(RIGHT($I$363)="P",Input!E18,IF(RIGHT($I$363)="X",-Input!E18,IF(RIGHT($I$363)="Y",Input!E18,IF(RIGHT($I$363,2)="XY",-Input!E18,IF(RIGHT($I$363)="S",Input!E18,"NG")))))
Problem here is:
If I select S543XY in I363 cell, I should get negative value, instead I am getting + value which I am getting from 3rd condition.
Can u please refine the code.
Thanks.
Just move the check for XY so it appears before the check for Y.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks