View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KLB KLB is offline
external usenet poster
 
Posts: 9
Default Help with Baseball Formula

Wow. that turned out to be a mess

Sorry

How about if I just put it:

B5 says =IF(B5B7,1,0) then I hid the results by using white font
B7 says =IF(B7B5,1,0) then I hid the results by using white font

I4 says =SUM(B5:H5)
I6 says =SUM(B7:H7)

J5 says =IF(I4I6,A4,A6)

would also like to extend formula to say
if I4=I6 then do not enter anything.in J5

Gee, talk about tongue-twisted, I feel like Porky-Pa-Pa-Pig

Thank you