Hi all,
Hopefully I'm just being dense and this will be a simple one for you.
Cell A1 contains a formula that produces 1 of 2 results; '1,000' (one-thousand) or '1,000,000' (one million). Used for rounding purposes in a reporting document.
Cell A2 contains the formula
which is intended to show the results in a text format. It SHOULD generate either the text '000s or '000,000s if the result is of A1 is 1,000 or 1,000,0000 respectively.
The problem I'm having is that regardless of the result in cell A1, the result in A2 remains '000s . This is the correct result if the result in cell A1 is 1,000, but it remains so even if the result in A1 is 1,000,000 - in this case A2 should generate a result of '000,000.
I know the issue is with the prescribed text format, but I've been staring at my screen for too long to be able to figure out why and my brain is suffering from Excel bloat
Hopefully I'm just being dense and this will be a simple one for you.
Cell A1 contains a formula that produces 1 of 2 results; '1,000' (one-thousand) or '1,000,000' (one million). Used for rounding purposes in a reporting document.
Cell A2 contains the formula
Excel Formula:
="'"&TEXT(RIGHT($A$1,LEN($A$1)-1),"000")&"s"
The problem I'm having is that regardless of the result in cell A1, the result in A2 remains '000s . This is the correct result if the result in cell A1 is 1,000, but it remains so even if the result in A1 is 1,000,000 - in this case A2 should generate a result of '000,000.
I know the issue is with the prescribed text format, but I've been staring at my screen for too long to be able to figure out why and my brain is suffering from Excel bloat