If Function Treating Answer as a Text Box and Not a Numeric Box

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.
 
T

T. Valko

Get rid of all those qoutes around the numbers:

=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)
 
T

T. Valko

mark

--
Biff
Microsoft Excel MVP


T. Valko said:
Get rid of all those qoutes around the numbers:

=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)
 
T

Tyro

I'm not sure what you want. You say "kick out values as text". I don't know
what that means. Your formulas are returning text.
Do you want them to return numerics? If so:

=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)

Tyro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top