software

I am setting up a simple golf scorecard and assigning quot;pointsquot; to pars,
birdies, etc. in an effort to pair players in a partnership competition based
on recent performance. One of the functions to assign points is
=IF(B3=4,quot;2quot;,IF(B3=3,quot;3quot;,IF(B3=2,quot;4quot;,IF(B3=5,quot;1quot;,I F(B3gt;5,quot;0quot;))))). I want to
total the points assigned for each hole but I am unable to do so with the SUM
function, it just returns quot;0quot;. I read in the quot;Helpquot; somewhere that it ignores
values returned from functions. Is there a way to override this and get the
function to read the values? I have never built a Macro but would that be a
solution? I want to retain the worksheet as a template so I would like to be
able to have it perform the functions without rebuilding the worksheet.
Thanks for any suggestions.
Duff Divot

Take the quotation marks out of your formula and it will SUM. They turned
the results into TEXT, which will not SUM.
Use this....

=IF(B3=4,2,IF(B3=3,3,IF(B3=2,4,IF(B3=5,1,IF(B3gt;5,0 )))))

Vaya con Dios,
Chuck, CABGx3

quot;Duff Divotquot; lt;Duff gt; wrote in message
...
gt; I am setting up a simple golf scorecard and assigning quot;pointsquot; to pars,
gt; birdies, etc. in an effort to pair players in a partnership competition
based
gt; on recent performance. One of the functions to assign points is
gt; =IF(B3=4,quot;2quot;,IF(B3=3,quot;3quot;,IF(B3=2,quot;4quot;,IF(B3=5,quot;1quot;,I F(B3gt;5,quot;0quot;))))). I want
to
gt; total the points assigned for each hole but I am unable to do so with the
SUM
gt; function, it just returns quot;0quot;. I read in the quot;Helpquot; somewhere that it
ignores
gt; values returned from functions. Is there a way to override this and get
the
gt; function to read the values? I have never built a Macro but would that be
a
gt; solution? I want to retain the worksheet as a template so I would like to
be
gt; able to have it perform the functions without rebuilding the worksheet.
gt; Thanks for any suggestions.
gt; Duff Divot
That was easy, I guess I was looking for a difficult answer. Thanks to you
for helping me out. It usually takes an independent set of eyes to see the
obvious. Thanks again.

quot;CLRquot; wrote:

gt; Take the quotation marks out of your formula and it will SUM. They turned
gt; the results into TEXT, which will not SUM.
gt; Use this....
gt;
gt; =IF(B3=4,2,IF(B3=3,3,IF(B3=2,4,IF(B3=5,1,IF(B3gt;5,0 )))))
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt;
gt; quot;Duff Divotquot; lt;Duff gt; wrote in message
gt; ...
gt; gt; I am setting up a simple golf scorecard and assigning quot;pointsquot; to pars,
gt; gt; birdies, etc. in an effort to pair players in a partnership competition
gt; based
gt; gt; on recent performance. One of the functions to assign points is
gt; gt; =IF(B3=4,quot;2quot;,IF(B3=3,quot;3quot;,IF(B3=2,quot;4quot;,IF(B3=5,quot;1quot;,I F(B3gt;5,quot;0quot;))))). I want
gt; to
gt; gt; total the points assigned for each hole but I am unable to do so with the
gt; SUM
gt; gt; function, it just returns quot;0quot;. I read in the quot;Helpquot; somewhere that it
gt; ignores
gt; gt; values returned from functions. Is there a way to override this and get
gt; the
gt; gt; function to read the values? I have never built a Macro but would that be
gt; a
gt; gt; solution? I want to retain the worksheet as a template so I would like to
gt; be
gt; gt; able to have it perform the functions without rebuilding the worksheet.
gt; gt; Thanks for any suggestions.
gt; gt; Duff Divot
gt;
gt;
gt;

or

=MAX(6-B3,0)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------quot;CLRquot; gt; wrote in message
...
gt; Take the quotation marks out of your formula and it will SUM. They turned
gt; the results into TEXT, which will not SUM.
gt; Use this....
gt;
gt; =IF(B3=4,2,IF(B3=3,3,IF(B3=2,4,IF(B3=5,1,IF(B3gt;5,0 )))))
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt;
gt; quot;Duff Divotquot; lt;Duff gt; wrote in message
gt; ...
gt;gt; I am setting up a simple golf scorecard and assigning quot;pointsquot; to pars,
gt;gt; birdies, etc. in an effort to pair players in a partnership competition
gt; based
gt;gt; on recent performance. One of the functions to assign points is
gt;gt; =IF(B3=4,quot;2quot;,IF(B3=3,quot;3quot;,IF(B3=2,quot;4quot;,IF(B3=5,quot;1quot;,I F(B3gt;5,quot;0quot;))))). I
gt;gt; want
gt; to
gt;gt; total the points assigned for each hole but I am unable to do so with the
gt; SUM
gt;gt; function, it just returns quot;0quot;. I read in the quot;Helpquot; somewhere that it
gt; ignores
gt;gt; values returned from functions. Is there a way to override this and get
gt; the
gt;gt; function to read the values? I have never built a Macro but would that be
gt; a
gt;gt; solution? I want to retain the worksheet as a template so I would like to
gt; be
gt;gt; able to have it perform the functions without rebuilding the worksheet.
gt;gt; Thanks for any suggestions.
gt;gt; Duff Divot
gt;
gt;
Assuming B3 can't be less than 0 of course, though that can also be catered
for.

Regards
Ken...................quot;Ken Wrightquot; gt; wrote in message
...
gt; or
gt;
gt; =MAX(6-B3,0)
gt;
gt; --
gt; Regards
gt; Ken....................... Microsoft MVP - Excel
gt; Sys Spec - Win XP Pro / XL 97/00/02/03
gt;
gt; ------------------------------*------------------------------*----------------
gt; It's easier to beg forgiveness than ask permission :-)
gt; ------------------------------*------------------------------*----------------
gt;
gt;
gt; quot;CLRquot; gt; wrote in message
gt; ...
gt;gt; Take the quotation marks out of your formula and it will SUM. They
gt;gt; turned
gt;gt; the results into TEXT, which will not SUM.
gt;gt; Use this....
gt;gt;
gt;gt; =IF(B3=4,2,IF(B3=3,3,IF(B3=2,4,IF(B3=5,1,IF(B3gt;5,0 )))))
gt;gt;
gt;gt; Vaya con Dios,
gt;gt; Chuck, CABGx3
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Duff Divotquot; lt;Duff gt; wrote in message
gt;gt; ...
gt;gt;gt; I am setting up a simple golf scorecard and assigning quot;pointsquot; to pars,
gt;gt;gt; birdies, etc. in an effort to pair players in a partnership competition
gt;gt; based
gt;gt;gt; on recent performance. One of the functions to assign points is
gt;gt;gt; =IF(B3=4,quot;2quot;,IF(B3=3,quot;3quot;,IF(B3=2,quot;4quot;,IF(B3=5,quot;1quot;,I F(B3gt;5,quot;0quot;))))). I
gt;gt;gt; want
gt;gt; to
gt;gt;gt; total the points assigned for each hole but I am unable to do so with
gt;gt;gt; the
gt;gt; SUM
gt;gt;gt; function, it just returns quot;0quot;. I read in the quot;Helpquot; somewhere that it
gt;gt; ignores
gt;gt;gt; values returned from functions. Is there a way to override this and get
gt;gt; the
gt;gt;gt; function to read the values? I have never built a Macro but would that
gt;gt;gt; be
gt;gt; a
gt;gt;gt; solution? I want to retain the worksheet as a template so I would like
gt;gt;gt; to
gt;gt; be
gt;gt;gt; able to have it perform the functions without rebuilding the worksheet.
gt;gt;gt; Thanks for any suggestions.
gt;gt;gt; Duff Divot
gt;gt;
gt;gt;
gt;
gt;