Copy cell if>0 to another cell
Solved/Closed
Related:
- Copy cell if>0 to another cell
- Conditional formatting if cell contains text - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- //192.168.l.0 - Guide
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Excel: If Date =, then enter a value ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 19, 2010 at 10:35 AM
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