Forum Discussion
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(...
The formula is in Portuguese, in your case use =IF(I5>0,CONCAT("VR-","cell where the month you want to appear is located";"-",A5),"")