Forum Discussion

2 Replies

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Mar 19, 2020

    hi johan_koopmans 

     

    further to the below post note that I missed to inform you about the separator

    ="<> werkelijke kosten* "&TEXT(D20*(F45/F43),"#,##0.00")

    Please use the above formula, attached is the revised file

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official Answer.

     

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Mar 19, 2020

    Hi johan_koopmans 

     

    Please construct your formula as below 

     

    ="<> werkelijke kosten* "&TEXT(D20*(F45/F43),"0.00")

     

     You need to use the text function to format your value

     

    also you can use round function 

     

    ="**werkelijke kosten "&D20&" verrekenen naar "&ROUND(F45,2)&""

     

     

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official Answer.

Resources