- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Part # Generator in Excel
Posted on 3/10/20 at 3:18 pm
Posted on 3/10/20 at 3:18 pm
Brilliant folk of The Tech Board,
I need some help with a part # generator spreadsheet I'm working on.
Column A is the part code, Column D is the quantity. I'm trying to make the part code from Column A, and the quantity from Column D, appear together in column F (ex: cell F20) - by just entering the quantity (in Column D). However, I want cells in Column F to stay blank if there is nothing in its corresponding quantity cell.
For example: type "3" into cell D22 and it appearing as "D3" in cell F22.
Any help is appreciated.
I need some help with a part # generator spreadsheet I'm working on.
Column A is the part code, Column D is the quantity. I'm trying to make the part code from Column A, and the quantity from Column D, appear together in column F (ex: cell F20) - by just entering the quantity (in Column D). However, I want cells in Column F to stay blank if there is nothing in its corresponding quantity cell.
For example: type "3" into cell D22 and it appearing as "D3" in cell F22.
Any help is appreciated.
2
Posted on 3/10/20 at 3:29 pm to PawnMaster
Go with =IF(D22 = "","",A22&""&D22)
It says if D22 is blank, output nothing, else combine A22 and D22. Might be a prettier way to do this, but this way works
It says if D22 is blank, output nothing, else combine A22 and D22. Might be a prettier way to do this, but this way works
Posted on 3/10/20 at 3:33 pm to FeeshTacos
Probably can take out the extra &"" there. Thats what I get for googling.
=IF(D22 = "","",A22&D22) also works
=IF(D22 = "","",A22&D22) also works
Posted on 3/10/20 at 3:50 pm to FeeshTacos
quote:
FeeshTacos
That's it! I appreciate it!
Posted on 3/10/20 at 4:20 pm to FeeshTacos
quote:
=IF(D22 = "","",A22&D22) also works
I'd actually use a isblank formula, but either way should get the same outcome.
=IF(ISBLANK(D22),"",A22&D22)
Posted on 3/10/20 at 7:47 pm to Weekend Warrior79
shite not me. no way im adding isblank if IF can handle it on its own. especially something this simple.
Posted on 3/11/20 at 9:30 am to PawnMaster
=If(isblank(D22),“ “, concatenate(A22,D22))
In cell F22; write that formula.
In cell F22; write that formula.
This post was edited on 3/11/20 at 9:35 am
Page 1 of 1
Back to top
Follow TigerDroppings for LSU Football News