Associate
- Joined
- 9 Jan 2006
- Posts
- 1,440
- Location
- Nottingham
hey all need a bit of help with excel.
i have an "if" function which works out stableford scores against par. i have the function working and returning the correct results (see the top bar for the function) but i cannot get excel to recognise the returned values and then add them up - see column I and the formula at the bottom.
so my question is, is it possible to add up those values returned by the function? or is there a way to turn the returned values into actual "numbers" so that excel recognises them?
here's a screenie to illustrate - i hope it's clear what im asking!
cheers
nin9a
i have an "if" function which works out stableford scores against par. i have the function working and returning the correct results (see the top bar for the function) but i cannot get excel to recognise the returned values and then add them up - see column I and the formula at the bottom.
so my question is, is it possible to add up those values returned by the function? or is there a way to turn the returned values into actual "numbers" so that excel recognises them?
here's a screenie to illustrate - i hope it's clear what im asking!
cheers
nin9a
