# Thread: Formula results in a text and need results to be a number

1. ## Formula results in a text and need results to be a number

The "IF" formula that was created also has embeded the "RIGHT(CELL REF, 6)"formula and if the conditions agree the 6 numbers are recorded in the cell, if the conditions do not agree then a zero is recorded in the cell. {ex: =IF(A1=670001,RIGHT(CELL REF,6),0)}

How to I get the resultant cell (WITH THE FORMULA)to become a numeric result and not alpha?

2. I don't understand the question. Text to values can be converted with the VALUE function, but I don't understand exactly what you doing. Could you elaborate, perhaps posting an example file?

Steve

3. In such cases, I usually add +0 to the formula.

zeddy

4. Does =IF(A1=670001,VALUE(RIGHT(CELL REF,6)),0) work?

5. You could probably use:
=(A1=670001)*RIGHT(CELL REF,6)
or, at most:
=(A1=670001)*--RIGHT(CELL REF,6)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•