Forum Discussion

Sheilveil's avatar
Sheilveil
Copper Contributor
Aug 29, 2022

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(...
excel
Formulas and Functions
LuanGomes's avatar
LuanGomes
Copper Contributor
Aug 29, 2022

Sheilveil 

 

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),"")