Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hey all good helping people.
I am trying to create a Modulo function to fill out a round/pick calculation in a draft type spreadsheet. Specifically, I want the value: 1 to show as 1:1 and the value: 12 to show as 1:12. The formula that I have now is: =ROUNDDOWN((P3/12)+1,0)&"/"&MOD(P3,12) (where the number is in P3) The formula works fine, until I get to the value of 12, then it calculates to 2:0 and not 1:12 (which is my goal). Do I need to add some if/then logic for when the modulo =0, then subtract one from the 1st part, and set the second part =12? Or is there a better way? |