B
Brettley
I'm creating a scoring matrix which auto assigns values based on another
cell's answer. At the end, i would like to sum all the values. However,
this function is not working as the data is being calculated as a text. How
would I change the following to get it to kick out values as text?
=IF(B19>=5,"8",IF(B19>=3,"6",IF(B19>=2,"4",IF(B19>=1,"2",IF(B19=0,"(-10)")))))
=IF(B13="Yes","1","(-4)")
Thank you very much in advance.
cell's answer. At the end, i would like to sum all the values. However,
this function is not working as the data is being calculated as a text. How
would I change the following to get it to kick out values as text?
=IF(B19>=5,"8",IF(B19>=3,"6",IF(B19>=2,"4",IF(B19>=1,"2",IF(B19=0,"(-10)")))))
=IF(B13="Yes","1","(-4)")
Thank you very much in advance.