Percentage value shown in thousands upon progress calculation based on dates

[marmanlive]

Hi Folks,

I have a simple dilemma that I can't get resolved.

I want to calculate progress in percentages in Excel with a given start date and end date so that no progress shows as 0% and the complete progress shows max 100%.
What I get in the output is the percentage in thousands.

I have tried almost any solution offered by Google and ChatGPT, I changed Excel formula settings, tried different MIN/MAX combinations, cell formatting, etc.
Nothing helped.

This was not the case in my Excel, I used to get normal percentage values, not sure what happened.

Latest formula used:

Please Login or Register  to view this content.

• The example worksheet attached

Any advice is appreciated.
/Marat

[TMS]

Wherever you have 100, change it to 1. 1 formatted as a percentage is 100%.

[marmanlive]

Wherever you have 100, change it to 1. 1 formatted as a percentage is 100%.

Hmmm... I wonder how should I make it 1 in the formula?

[JEC.]

What he means is just this

Please Login or Register  to view this content.

[TMS]

@JEC: That's exactly what I meant. Thank you.

100.00% =IF(TODAY() < A2, 0, IF(TODAY() > C2, 1, MIN((TODAY() - A2) / (C2 - A2) * 1, 1)))
100.00% =IF(TODAY() < A3, 0, IF(TODAY() > C3, 1, MIN((TODAY() - A3) / (C3 - A3) * 1, 1)))
100.00% =IF(TODAY() < A4, 0, IF(TODAY() > C4, 1, MIN((TODAY() - A4) / (C4 - A4) * 1, 1)))
100.00% =IF(TODAY() < A5, 0, IF(TODAY() > C5, 1, MIN((TODAY() - A5) / (C5 - A5) * 1, 1)))
100.00% =IF(TODAY() < A6, 0, IF(TODAY() > C6, 1, MIN((TODAY() - A6) / (C6 - A6) * 1, 1)))
85.71% =IF(TODAY() < A7, 0, IF(TODAY() > C7, 1, MIN((TODAY() - A7) / (C7 - A7) * 1, 1)))
100.00% =IF(TODAY() < A8, 0, IF(TODAY() > C8, 1, MIN((TODAY() - A8) / (C8 - A8) * 1, 1)))
0.00% =IF(TODAY() < A9, 0, IF(TODAY() > C9, 1, MIN((TODAY() - A9) / (C9 - A9) * 1, 1)))
0.00% =IF(TODAY() < A10, 0, IF(TODAY() > C10, 1, MIN((TODAY() - A10) / (C10 - A10) * 1, 1)))