|
|
|
|
|
| |
 Answer |
|
| |
Your formula isn't returning numbers....
it's returning *letters* that look like numbers
=IF(B3=$B$2+1,"1",IF(B3=$B$2,"2",IF(B3=$B$2-1,"4",IF(B3=$B$2-2,"8","0"))))
Putting quotes around anything turns it into text.
Try this:
=IF(B3=$B$2+1,1,IF(B3=$B$2,2,IF(B3=$B$2-1,4,IF(B3=$B$2-2,8,0))))
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Golf Nut" wrote:
> I used multiple IF statements to return a number from 0 to 8. I now need to
> sum the results of the returned numbers in a row. When I use =Sum(A7:J7) it
> returns 0. How do I get a total on this Row?
>
> Copy of statement
> =IF(B3=$B$2+1,"1",IF(B3=$B$2,"2",IF(B3=$B$2-1,"4",IF(B3=$B$2-2,"8","0")))) |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
|
|
| |
Remove the quotes from your numbers, since that makes them Text, and Sum()
ignores Text.
=IF(B3=$B$2+1,1,IF(B3=$B$2,2,IF(B3=$B$2-1,4,IF(B3=$B$2-2,8,0))))
OR,
Change your totaling formula to:
=A7+B7+C7+D7+E7+F7+G7+H7+I7+J7
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Golf Nut" <Golf Nut@discussions.microsoft.com> wrote in message
news:9737BEA0-60A8-49E7-B96C-2B74A27333AE@microsoft.com...
>I used multiple IF statements to return a number from 0 to 8. I now need
>to
> sum the results of the returned numbers in a row. When I use =Sum(A7:J7)
> it
> returns 0. How do I get a total on this Row?
>
> Copy of statement
> =IF(B3=$B$2+1,"1",IF(B3=$B$2,"2",IF(B3=$B$2-1,"4",IF(B3=$B$2-2,"8","0"))))
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
Question
Notify me of replies