Cellanator
New Member
- Joined
- Dec 31, 2020
- Messages
- 3
- Office Version
- 2016
Is it possible to use ROUNDDOWN with Text in the same cell?
The problem I'm having is it changes the formatting from a % to something else.
Where it would show 100% now show's .999 and 1.0 when 100% is achieved.
My Formula in cell ...... =TEXT((L13/K13),"###%")&" PAID"
L13 = 24,117.02
K13 = 24,117.35
Shows 100% when not fully paid!
So I used the ROUNDDOWN FUNCTION, however I loose the % formatting if I add Text of "Paid" to the end.
=ROUNDDOWN((L13/K13),3)&" Paid" will show 0.999 Paid and 1.0 when 100% instead of showing 99.9 % and 100.0%
How can I use the Rounddown function with text or is there a better solution?
Dave
The problem I'm having is it changes the formatting from a % to something else.
Where it would show 100% now show's .999 and 1.0 when 100% is achieved.
My Formula in cell ...... =TEXT((L13/K13),"###%")&" PAID"
L13 = 24,117.02
K13 = 24,117.35
Shows 100% when not fully paid!
So I used the ROUNDDOWN FUNCTION, however I loose the % formatting if I add Text of "Paid" to the end.
=ROUNDDOWN((L13/K13),3)&" Paid" will show 0.999 Paid and 1.0 when 100% instead of showing 99.9 % and 100.0%
How can I use the Rounddown function with text or is there a better solution?
Dave