Forum Discussion
Solved
Format Cells Number not returning number value for chart data
Formula below, returns a numerical value. Works fine
=IF(F3="A","5",IF(F3="B","4",IF(F3="C","3",IF(F3="D","2",IF(F3="E","1",IF(F3="N","0",""))))))
Then when trying to represent cell value as a number, Sample always returns the text value. The error then prevents the data being used to create a scatter plot chart as the value returned is 0.00.
"5" if text (a string). 5 (without quotes) is numeric.
The format of the cell does not convert text ("5") into a numeric value (5).
2 Replies
"5" if text (a string). 5 (without quotes) is numeric.
The format of the cell does not convert text ("5") into a numeric value (5).
- Thank you!! Knew it would be a simple fix.
