# Posts by Hoops

• ## greater than less that plus add

Re: greater than less that plus add

thanks VB will try it out

• ## greater than less that plus add

what is the formula to if B1 id greater than 0 but less than six add A1*1, if B1 is greater than 5 but less that 11 add A1*2, if B1 is greater than 10 but less than 16 add A1*2 plus A2*1, if B1 is greater than15 but less than 21 add A1*2 plus A2*2

• ## want to collate text from different cells with a return

Re: want to collate text from different cells with a return

Hi jindon
that seems to have done it - many many thanks

• ## want to collate text from different cells with a return

Re: want to collate text from different cells with a return

ok will check it out and get back to you
Thanks

• ## want to collate text from different cells with a return

Re: want to collate text from different cells with a return

jindon if you could repost in .xls format it would be appreciated
Thanks

• ## want to collate text from different cells with a return

Re: want to collate text from different cells with a return

ah! im using xls not xlsx - need to update i guess

• ## want to collate text from different cells with a return

Re: want to collate text from different cells with a return

Hi Jindon
Thanks but I cant get that formula to work, Error Code

• ## want to collate text from different cells with a return

I am trying to collate text from corresponding cells in different sheets into a final sheet. e.g using A1 cells in four sheets, sheet 4 would duplicate the text in sheet 1 A1 would be added, then then text in sheet 2 A1 and then the text in sheet 3 A1 as a list. The formula I have is

=
\$Sheet1.A1&CHAR(10)&\$Sheet2.A1&CHAR(10)&\$Sheet3.A1&CHAR(10)

so if Sheet 1 A1 has 'hello' Sheet2 A1 has 'hows' Sheet3 A1 has 'you' Sheet4 A1 would have
hello
hows
you
However the problem with this is that even when there is no text in a corresponding cell the formula still inserts a return so if Sheet2 A1 is empty it looks like
hello

you
I don't want the return to be used in Sheet4 if no text is in the corresponding cell, but if there is text in the corresponding cell I want it to be in Sheet4 with a return, thus forming a list.
hope that all makes sense
Thanks
Hoops