Copy cell if>0 to another cell
Solved/Closed
Related:
- Copy cell if>0 to another cell
- Copy row only if one cell's value is not 0 ✓ - Forum - Excel
- ConditionalFormating: if cell a1 = 0% to 50% ✓ - Forum - Office Software
- In cell C12 if>0 Copy C12 and A12 to A63 ✓ - Forum - Office Software
- How to hide/undie picture based on a cell A1=1/0? ✓ - Forum - Excel
- Excel fill 0 in blank cells ✓ - Forum - Programming
1 reply
TrowaD
Oct 19, 2010 at 10:35 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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,
Trowa
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,
Trowa
Oct 19, 2010 at 11:56 AM
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,
Steve