The following formula in cell N23 delivers the correct mathematical result: 0.370165745856354 =IF(N22>"",SUM(M19:M22)/SUM(M14:M17),
IF(N21>"",SUM(M19:M21)/SUM(M14:M16),
IF(N20>"",SUM(M19:M20)/SUM(M14:M15),
N19)))
In cell I23, with formula =CONCATENATE("Total 2019 travel: ",M23," days"," (",N23,")") the N3 result is displayed as 0.370165745856354. I want it however to be displayed as 37%
I've tried to format the N23 result to present 37%, by embedding =text formula:=TEXT(IF(N22>"",SUM(M19:M22)/SUM(M14:M17),"0%"),
TEXT(IF(N21>"",SUM(M19:M21)/SUM(M14:M16),"0%"),
TEXT(IF(N20>"",SUM(M19:M20)/SUM(M14:M15),"0%"),
TEXT(N19,"0%"))))
That does provide the required percentage format in N23 and I23, but the mathematical result is wrong (iso 37% it now is 42%).
What am I doing wrong?
Bookmarks