Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
I reckon this would do the trick: =IF(B1<=A1+2,B1,6) where b1 is score and a1 is par -- mattjenkins ------------------------------------------------------------------------ mattjenkins's Profile: http://www.excelforum.com/member.php...o&userid=36049 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
matt your a diamond:) just tried and it works so i'll carry on with par3's and 5's thnx ever so much -- bronking ------------------------------------------------------------------------ bronking's Profile: http://www.excelforum.com/member.php...o&userid=35762 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
"bronking" wrote in
message ... 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 =MIN(B1,A1+2) or =MIN(B1,6) depending on what your rules are. -- David Biddulph |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
thnx for help:) another question (related to above) some players put in a non return on a hole (lets call it n) how do i add this to formula so that when i input n the value will be +2 of the par (colunm A) ps i ve worked out first handicap yehaaaaaaa:) -- bronking ------------------------------------------------------------------------ bronking's Profile: http://www.excelforum.com/member.php...o&userid=35762 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
using my formula it would be this =IF(b1="n",a1+2,if(B1<=A1+2,B1,6)) Matt -- mattjenkins ------------------------------------------------------------------------ mattjenkins's Profile: http://www.excelforum.com/member.php...o&userid=36049 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
Possibly =IF(B1="","",IF(ISNUMBER(B1),MIN(B1,A1+2),A1+2)) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
just tried (brilliant:) ) thanx again matt cheers david and daddy for input -- bronking ------------------------------------------------------------------------ bronking's Profile: http://www.excelforum.com/member.php...o&userid=35762 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
last q (promise, for today) if "n" is inputed how do i make the column come up with number (2 more than par) for instance par 4 (score n) net 6 thnx to matt it does the formula to get 6, but total gross won't properly add up as in par I grs I net 4 I 6 I 6 4 I 7 I 6 4 I n I 6 tot I ? I 18 or better still leave it showing n but twiddle with auto sum to say when n use net score -- bronking ------------------------------------------------------------------------ bronking's Profile: http://www.excelforum.com/member.php...o&userid=35762 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
If the range with the "n"s is B1:B10 then use this formula to sum assuming n=6 =SUM(B1:B10)+COUNTIF(B1:B10,"n")*6 note if you want the formula to automatically sum n as 2 more than par then try =SUM(B1:B10)+COUNTIF(B1:B10,"n")*(A1+2) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
Edit to last post: typo in formula, should be =SUM(B1:B10)+COUNTIF(B1:B10,"n")*6 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
to daddylonglegs (or anyone who might know) =SUM(B1:B10)+COUNTIF(B1:B10,"n")*(A1+2) dosn't work problem with countif part of formulae anybody any ideas ? -- bronking ------------------------------------------------------------------------ bronking's Profile: http://www.excelforum.com/member.php...o&userid=35762 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
Assuming A1 contains par, e.g. 4 then =SUM(B1:B10)+COUNTIF(B1:B10,"n")*(A1+2) works OK when I test it What result do you get? What do you mean there is a problem with COUNTIF? -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
hey up m8 :) see piccy +-------------------------------------------------------------------+ |Filename: count.jpg | |Download: http://www.excelforum.com/attachment.php?postid=4980 | +-------------------------------------------------------------------+ -- bronking ------------------------------------------------------------------------ bronking's Profile: http://www.excelforum.com/member.php...o&userid=35762 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
Looks like you're using Microsoft Works which isn't the same as Microsoft Excel. Have you got Excel? COUNTIF will work there... -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
#16
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 -- bronking ------------------------------------------------------------------------ bronking's Profile: http://www.excelforum.com/member.php...o&userid=35762 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
#17
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
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 -- bronking ------------------------------------------------------------------------ bronking's Profile: http://www.excelforum.com/member.php...o&userid=35762 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
#18
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
Based on your previous screenshot try this formula in C21 =SUM(C3:C20)+SUMPRODUCT(--(C3:C20="n"),B3:B20+2) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
#19
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
....or an array formula which need to be confirmed with CTRL+SHIFT+ENTER =SUM(IF(C3:C20="n",B3:B20+2,C3:C20)) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=558421 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |