take it easy (first post):)
golf

if in column a (par 4) and column b (is score )
for colunm c: what/how if for to say if column b is value + 2 upto 6

so that if i hit a 4 on a par 4 c would come out 4
a 5 would come out 5
a 6 would come out 6
a 7 would come out 6
an 8 would come out 6 and so on

hopefully if i understand this i'll be able to work out par3's and 5's

any reply greatly appreciated


--
bronking
------------------------------------------------------------------------
bronking's Profile: http://www.excelforum.com/member.php...o&userid=35762
View this thread: http://www.excelforum.com/showthread...hreadid=558421