Hi sir, If i want to find last three numbers ending with "1.90 and also 1.85" then only it should be visible in in "C2" otherwise it should stay blank, like the way it is in below image, Below formula is working fine for finding numbers ending with" 1.90" but i want it to find also ending with "1.85" also from B2 and show in "C2" or if not found stay blank
Attachment 551052
IF(ISERROR(SEARCH("1.9",TEXT(B2,"@"),1)),"",B2)
Last edited by feroz763; 12-07-2017 at 04:33 PM.
feroz763, Good morning.
I'm not sure if I understood your question correctly.
Try to use:
C2 --> =IF(OR(B2=1.85,B2=1.9),B2,"")
Copy this formula down.
Format the C column to numeric with 2 decimal places.
Please, tell us if it worked as you wanted.
I hope it helps.
...If my answer helped you, Please, click on. * Add Reputation (at left)
Best regards.
Marc?lio Lob?o
Hi sir, in below formula i am able to find "1.90" i also want to find "1.85" also from same cell please help.
=IF(ISERROR(SEARCH("1.90",TEXT(b2,"@"),1)),"",b2)
What Marcilio gave you should work fine for what you "seem" to be wanting. Could you be more clear about what you are trying to do and how Marcilio's formula fails?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Hi sir, If i want to find last three numbers ending with "1.90 and also 1.85" then only it should be visible in in "C2" otherwise it should stay blank, like the way it is in below image, Below formula is working fine for finding numbers ending with" 1.90" but i want it to find also ending with "1.85" also from B2 and show in "C2" or if not found stay blank
forumala.jpg
IF(ISERROR(SEARCH("1.9",TEXT(B2,"@"),1)),"",B2)
Last edited by feroz763; 12-07-2017 at 04:32 PM.
That changes the requirements completely...
Try this in C2:
=IF(OR(RIGHT(TEXT(B2,"0.00"),4)={"1.90","1.85"}),B2,"")
Thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks