Convert raw ADP into ADP by round in Excel (1 Viewer)

[The Goose is Loose]

Any excel experts out there who know how to do this?  I have raw ADP info but want to have it listed in my spreadsheet by round.  I'm in a 12 team league.  For example, an ADP of 26 = 2.02

Any help would be appreciated.

 

[CalBear]

Any excel experts out there who know how to do this?  I have raw ADP info but want to have it listed in my spreadsheet by round.  I'm in a 12 team league.  For example, an ADP of 26 = 2.02

Any help would be appreciated.

Round is =ROUNDUP(12/<cell>,0). Pick is =MOD(<cell>,12). (For 12 teams).

 

[ZWK]

If the pick is in A1, a formula that would work is:

=CEILING(A1/12,1)+0.01*(A1-12*(CEILING(A1/12,1)-1))

 

[The Goose is Loose]

If the pick is in A1, a formula that would work is:

=CEILING(A1/12,1)+0.01*(A1-12*(CEILING(A1/12,1)-1))

Perfect!  That worked great.

@CalBear - thanks for the response but your solution didn't work correctly.