Hi,
I need a forumula to look at 3 cells A1,A2,A3 and if A1 shows a value greater than 0 then in B1 it will show "RADS", if A2 greater then 0 then B1 shows "UFH" and if A3 greater than 0 then B1 will show "FAN".
If all more than one of the A cells are greater than B1 will show more than one result.
Example:
A1 = 4
A2 = 2
A3 = 2
B1 = RADS UFH FAN
or
A1 = 4
A2 = 0
A3 = 2
B1 = RADS FAN
If A cells are blank then B1 will be blank.
Thanks
Jon
In B1:
=TRIM(IF(A1>0,"RADS","")&IF(A2>0," UFH","")&IF(A3>0," FAN",""))
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
I'd just add a TRIM to Speshul's equation
=TRIM(IF(A1>0,"RADS","")&IF(A2>0," UFH","")&IF(A3>0," FAN",""))
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Beatcha to it!
My sig doesn't lie :p
LOL Yes you did
Enter this in B1
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks