Copy cell if>0 to another cell

help pls - Oct 19, 2010 at 10:16 AM
 startbuck - Oct 19, 2010 at 11:56 AM
I'm trying to find the best way to do the following:
A63 cell
=if(C12>0,C12&" "&A12," ")
A64 cell
=if(C13>0,C13&" "&A13," ")
etc.... this gives the value in cell C12, a space, and then the text in A12, or blank.
I would like the formula to be in cell C12 and send the result if >0 to cell A63. If C12 is
blank, do nothing. Then go to the next cell C13 and if C12 didn't populate A63, C13 would.
Thank you

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
Oct 19, 2010 at 10:35 AM
Hi Steve,

It looks to me like you want two things:
If C12 is blank, do nothing
if C12 didn't populate A63, C13 would

So it's either:
=if(C12>0,C12&" "&A12," ") or,
=if(C12>0,C12&" "&A12,C13&" "&A13)

I can't imagine that this is the answer, so where did I misunderstood you?

Best regards,
Hi TrowaD,
Thank you for the quick response. Thank you!
This is the first time I've asked a question. I didn't understand to leave a comment here. So, I left the quetion back in the ask a question section. I hope that doesn't confuse anyone. If I need to ask the question again in this location, please let me know. I'll pre word the issue this time so it will make sense.
Thank you again,