I have a formula in Q3, R3, S3, and T3 that delets the text from Q2 through T2 respectively thus leaving only the nubmbers that found in those cells. Now I need to place a text descriptor in A3 that identifies if any of the cells Q3 through T3 contain numbers. I tried using a helper cell of ifblank, but it sees the formulas in those cells. Any ideas?
Last edited by vnetmanager; 01-25-2013 at 02:42 PM.
Try in A3:
=OR(ISNUMBER(Q3:T3))
returns TRUE if number found, FALSE if not
Quang PT
It always gives False. I think because of the formulas in Q3:T3.
Hi vnet,
I think bebo's formula is an array-formula... so it requires an array-enter... instead of just ENTER, you must use CTRL-SHIFT-ENTER...
Also, make sure your numbers are not text... you can simply surround your formula with a TEXT formula... =TEXT(formula,"#")
Hope that helps... sorry for stepping on your toes, bebo... nice formula, by the way...
bebo021999 omitted
Its an Array formula
Use Ctrl-Shift Enter
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Q2 is ='Raw Data'!Q2 with an output of ADL 16 34567
Q3 is =TEXT(REPLACE(R2,SEARCH("ADL 16",Q2),6,""),"#") with an output of 34567
U3 is {=OR(ISNUMBER(Q3))} with an output of FALSE
What have I messed up here?
My mistake...
Don't use TEXT... I meant VALUE (sorry brain fart)
So for Q3 =VALUE(REPLACE(R2,SEARCH("ADL 16",Q2),6,""))
Your last thread, along with formatting the cells as a number, did the trick.
Thanks to all.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks