How do I sum values returned from functions?
 

I am setting up a simple golf scorecard and assigning "points" 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,"2",IF(B3=3,"3",IF(B3=2,"4",IF(B3=5,"1",I F(B35,"0"))))). I want to
total the points assigned for each hole but I am unable to do so with the SUM
function, it just returns "0". I read in the "Help" 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

How do I sum values returned from functions?
 

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(B35,0 )))))

Vaya con Dios,
Chuck, CABGx3




"Duff Divot" <Duff wrote in message
...
I am setting up a simple golf scorecard and assigning "points" 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,"2",IF(B3=3,"3",IF(B3=2,"4",IF(B3=5,"1",I F(B35,"0"))))). I want
to
total the points assigned for each hole but I am unable to do so with the
SUM
function, it just returns "0". I read in the "Help" 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

How do I sum values returned from functions?
 

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.

"CLR" wrote:

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(B35,0 )))))

Vaya con Dios,
Chuck, CABGx3




"Duff Divot" <Duff wrote in message
...
I am setting up a simple golf scorecard and assigning "points" 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,"2",IF(B3=3,"3",IF(B3=2,"4",IF(B3=5,"1",I F(B35,"0"))))). I want
to
total the points assigned for each hole but I am unable to do so with the
SUM
function, it just returns "0". I read in the "Help" 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

How do I sum values returned from functions?
 

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 :-)
------------------------------*------------------------------*----------------


"CLR" wrote in message
...
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(B35,0 )))))

Vaya con Dios,
Chuck, CABGx3




"Duff Divot" <Duff wrote in message
...
I am setting up a simple golf scorecard and assigning "points" 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,"2",IF(B3=3,"3",IF(B3=2,"4",IF(B3=5,"1",I F(B35,"0"))))). I
want
to
total the points assigned for each hole but I am unable to do so with the
SUM
function, it just returns "0". I read in the "Help" 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

How do I sum values returned from functions?
 

Assuming B3 can't be less than 0 of course, though that can also be catered
for.

Regards
Ken...................


"Ken Wright" wrote in message
...
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 :-)
------------------------------*------------------------------*----------------


"CLR" wrote in message
...
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(B35,0 )))))

Vaya con Dios,
Chuck, CABGx3




"Duff Divot" <Duff wrote in message
...
I am setting up a simple golf scorecard and assigning "points" 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,"2",IF(B3=3,"3",IF(B3=2,"4",IF(B3=5,"1",I F(B35,"0"))))). I
want
to
total the points assigned for each hole but I am unable to do so with
the
SUM
function, it just returns "0". I read in the "Help" 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