Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-13-2017, 03:28 AM
bishweshwar bishweshwar is offline ISNUMBER formula not working Windows 7 64bit ISNUMBER formula not working Office 2013
Novice
ISNUMBER formula not working
 
Join Date: Mar 2017
Posts: 3
bishweshwar is on a distinguished road
Default ISNUMBER formula not working

Text in cell E152: abc - India

1. formula1 applied on E152 (works correctly):



=TRIM(RIGHT(E152,(LEN(E152)-FIND("-",E152))))
==> output = India


2. formula2 applied on E152 (works correctly):

=ISNUMBER(SEARCH("India", E152))
==> output = TRUE

3. formula3 applied on E152 (doesn't work as expected):
replaced text "India" with formula in step 1

=ISNUMBER(SEARCH("TRIM(RIGHT(E152,(LEN(E152)-FIND("-",E152))))", E152))
==> output = FALSE (am expecting the output to be TRUE)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
ISNUMBER formula not working Formula working wrong, I can't identify why. rajeshn_in Excel 1 01-09-2017 03:59 AM
ISNUMBER formula not working Conditional formatting not working with simple formula bendmc Excel 2 11-17-2016 11:31 AM
ISNUMBER formula not working VLOOKUP Formula is not working babs1234 Excel 3 03-04-2015 06:08 AM
ISNUMBER formula not working IF, ISNUMBER & AND function Dkline Excel 3 06-04-2014 06:40 AM
ISNUMBER formula not working Equation formula EQ \F(a,b) for fractions w/horizontal line not working Manny Word 1 09-30-2013 03:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft