Most Accurate MLB Experts Past 4 Years
Moderator: Baseball Moderators
jfox72 wrote:This is for my keeper baseball league. Every player is given a guarenteed or non guarenteed contract. In the excel program they are designated as a G or NG and followed by the contract length, ex. NG-3 would be a non guarenteed 3 year deal. Every year a NG deal goes up higher than a G deal. I am looking for a formula to punch in that would automatically award the next seasons raises without me having to go in and manually enter them. This is an example of the sheet.
Name Salary($) Contract
Mark Buehrle 8 NG-3
Brett Myers 10 NG-4
David Wright 32 G-3
Todd Walker 0
Jesse Crain 3 G-3
Bobby Crosby 10 NG-3
Jorge Posada 5
Ron Belliard 4 NG-4
Jim Edmonds 20 NG-4
Matthias wrote:You can make an embedded if function for guaranteed and non-guaranteed, but it would probably just be easier to sort by it and make two different formulas.
For guaranteed, you can write it as (assuming your salary info is in B1):
If(B1<21,B1+1,if(B1<41,B1+2,B1+3)))
And then non-guaranteed would be:
If(B1<21,B1+3,if(B1<31,B1+4,if(B1<41,B1+5,if(B1<51,B1+6,B1+7))))
=IF(C2="","",LEFT(C2,FIND("-",C2)-1))
=IF(D2="","",IF(D2="G",IF(B2<21,B2+1,IF(B2<41,B2+2,B2+3)),IF(B2<21,B2+3,IF(B2<31,B2+4,IF(B2<41,B2+5,IF(B2<51,B2+6,B2+7))))))
Users browsing this forum: No registered users and 2 guests