Posted to microsoft.public.excel.misc

dpayne

external usenet poster

Posts: 3

logical test and concatenate(string)

I am looking for a formula that will find non zeros in column A and string
columns A & B, where there are a least 50 rows of information. The stringed
cells should be seperated by "," and a space. I have the following formula
but it becomes to big to fit in the cell.

=if(a1<0,a1&" "&b1&","&" ","")&if(a2<0,a2&" "&b2&","&" ","")&if(a3....etc)

I appreciate the help

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Logical test	retiredguy	New Users to Excel	2	January 27th 07 05:56 PM
logical test	LisaD	Excel Worksheet Functions	3	August 8th 06 03:24 PM
logical test	Ron Coderre	Excel Worksheet Functions	0	August 7th 06 08:02 PM
Concatenate a Logical Test	Sloth	Excel Discussion (Misc queries)	6	December 6th 05 07:35 PM
Logical test	Sooraj	Excel Discussion (Misc queries)	2	January 25th 05 12:59 PM

All times are GMT +1. The time now is 09:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us