Thread: excel help
View Single Post
Old 06-07-2007, 21:56   #8 (permalink)
aliando
-
 
Join Date: 12 Aug 2005
Age: 32
Posts: 21,013
Awards Showcase
Daily Horse Racing Competition Top Class Glory Hunter European & Worldwide Competition Supercup (I) European & Worldwide Competition KO Cup 
Total Awards: 5
Default Re: excel help
Quote:
Originally Posted by GotaFancy? View Post
Remove the quotes in S35

=IF(R35=3,3,IF(R35=1,1,IF(R35=0,-1)))






works a treat mate!


thanks (again ) - superb stuff
__________________
the charity trail-http://www.punterslounge.com/forum/s...d=1#post631758

Quote:
I am the most anti-social person I know. But of course, I don't know anyone because I'm so anti-social. Derek Neitzel.
aliando is offline   Reply With Quote