Can you attach a copy here?
Sorry, I'm still not following you. If I could look at an actual example, that would help.
OK, so tell me, are you trying to populate C with the number in B and then "-1"? And populate D with the number in B and "-3"?
OK, so it's the answer I put on the other question. If the number is ***** column B, the the formula for C2 is =CONCATENATE(B2,"-1") and the formula for D2 is =CONCATENATE(B2, "-3"). And then you copy the formula down.
You can get a little fancier to exclude blanks with:
=IF(B2>0, CONCATENATE(B2,"-1"), "") and =IF(B2>0, CONCATENATE(B2, "-3"), "")
You probably started in the wrong cell. if the formula says "B2", you have to put the formula on Row 2 for C and D. When you copy it down, Excel automatically increases the row number for you. But if you don't start in the right place, your numbering will be off.
Let me do it and I'll send it back to you, hold on.
Hi there, sorry I wasn't available on Friday. I attached the document here with the formulas in columns C and D. Chat me back if you want to discuss this further. Hope you had a good holiday weekend!