Forum Discussion
Sheilveil
Aug 29, 2022Copper Contributor
IF with cells containing text & numbers
Hello! I'm trying to have an invoice number automatically create using a cell that contains a number and a different one containing text. It needs to read VR-MONTH-COMPANY # (VR-JULY-200). Using =IF(I5>0,TEXT(A5,"VR-###"),""), I can get the VR-200 but need to put the month in the correct place between the VR and the Company # each month as data is entered. Thanks!
2 Replies
- LuanGomesCopper ContributorThe formula is in Portuguese, in your case use =IF(I5>0,CONCAT("VR-","cell where the month you want to appear is located";"-",A5),"")
- LuanGomesCopper Contributor
Hi, I believe I can do it this way
=SE(I5>0,CONCAT("VR-","cell where the month you want to appear is located";"-",A5),"")