Thread: if function

do you know i was just wondering if that was the prob (honest )

yes your right i'm using microsoft works

i assumed (wrongly) that they were compatable/sameish

thanx m8 i'll sort a copy of excel

right now with excel (borrowed daughters computor)

the formula that dadylonglegs gave does work but...

whenever "n" is inputed it only it only counts it as one value (ie 2 over par (hole1)
i need it to count it as 2 over par on which ever hole it is (par3's,4's and 5's)

hope ive explained myself properly

any ideas

Based on your previous screenshot try this formula in C21

=SUM(C3:C20)+SUMPRODUCT(--(C3:C20="n"),B3:B20+2)

....or an array formula which need to be confirmed with CTRL+SHIFT+ENTER

=SUM(IF(C3:C20="n",B3:B20+2,C3:C20))