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(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

  • LuanGomes's avatar
    LuanGomes
    Copper Contributor
    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),"")
  • LuanGomes's avatar
    LuanGomes
    Copper Contributor

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