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 ...
"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).
"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.