Thread: if function
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bronking bronking is offline
external usenet poster
 
Posts: 1
Default 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