I am working in google docs, in the spreadsheets section trying to figure out some custom functions. Working with text and numbers.

what i am wanting to do:

Code:

if (Cell:cell) = blank
Then
concat(a5,b5,c5 etc)
else
leave cell blank


what i have right now

Code:

=IF(COUNTBLANK(F5)=1;"Blank cell";"Not blank") TO_TEXT(A5) CONCATENATE(A5,B5,A3,F5,D5)


it is throwing a formula parse error.

The count blank part i found online, because i was unable to find a function that did quite what i wanted it too, and i thought that would work.

each of the rows i am sorting has one of 5 groups, i was wondering if i could then sort these by their group to make it easier to copy and paste them as a bunch and send there where they need to go.

example Group 1:
all the group 1 rows. as a single string after the concat.
Group 2:
all the group 2 rows.

its fine if they have to be in a different spot of the concat. (which i think they would have to be.


EDIT: Question was resolved by a friend that is a pro on google docs, he just wasnt on at the time of this post.

if anyone was curious on the code that replaced mine.


Code:

=if(F5="","",CONCATENATE(A5," ",B5," ",A$3," ",F5," ",D5))

much easier than what i was doing.
  
Register to Join the Conversation
Have your own thoughts to add to this or any other topic? Want to ask a question, offer a suggestion, share your own programs and projects, upload a file to the file archives, get help with calculator and computer programming, or simply chat with like-minded coders and tech and calculator enthusiasts via the site-wide AJAX SAX widget? Registration for a free Cemetech account only takes a minute.

» Go to Registration page
Page 1 of 1
» All times are UTC - 5 Hours
 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

 

Advertisement