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

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

Relevant Pages

  • RE: Count Fields on a Form or SubForm
    ... Ok, so I made the new table as suggested, with just the ID Number, an auto ... ID, CType, CDate, and CTime.... ... want that sum (total number of Family contacts, ...
    (microsoft.public.access.formscoding)
  • Re: work only with value without updating
    ... you could easily create a one variable data table ... *It can any empty cell outside of the range C2:D11 ... and must do it in many time, in other world i need sum of many random ... but this have 3 realy big problem and that is you must use auto fill step by ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Fortran vs. C++ : Which is best to choose now i
    ... > and calculate the average and standard deviation for both times. ... auto = 7.039 ... alloc = 7.404 ... * time calc'ing sum ...
    (comp.lang.fortran)
  • work only with value without updating
    ... and must do it in many time, in other world i need sum of many random ... number in many time and each time must give a seperate number of sum. ... but this have 3 realy big problem and that is you must use auto fill step by ... cell to have sum of past value that maked with random function, ...
    (microsoft.public.excel.worksheet.functions)