RE: If Function Treating Answer as a Text Box and Not a Numeric Box
- From: T. Valko <TValko@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 15 Apr 2008 14:21:00 -0700
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)
--
Biff
Microsoft Excel MVP
"Brettley" wrote:
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.
- Follow-Ups:
- References:
- Prev by Date: RE: Using AND and SUMIF function together
- Next by Date: RE: cell alignment
- Previous by thread: If Function Treating Answer as a Text Box and Not a Numeric Box
- Next by thread: Re: If Function Treating Answer as a Text Box and Not a Numeric Box
- Index(es):
Relevant Pages
|
