Formula Suggestion

[Ward]

I'm currently using the formula below to calculate the number entered in C1:

=IF(C1="","",IF(C1<99,"1st",TRUNC((C1-99)/84,0)+2&MID("thstndrdth",MIN(9,2*RIGHT(TRUNC((C1-99)/84,0)+2)*(MOD(TRUNC((C1-99)/84,0)+2-11,100)>2)+1),2)))

I now need the formula to calculate increments of 183 beginning at 211 not
98 like above. Would this work:?

=IF(C5="","",IF(C5<212,"1st",TRUNC((C5-212)/183,0)+2&MID("thstndrdth",MIN(9,2*RIGHT(TRUNC((C5-212)/183,0)+2)*(MOD(TRUNC((C5-212)/183,0)+2-11,100)>2)+1),2)))

 

[p45cal]

I'm currently using the formula below to calculate the number entered i
C1:

=IF(C1="","",IF(C1<99,"1st",TRUNC((C1-99)/84,0)+2&MID("thstndrdth",MIN(9,2*RIGHT(TRUNC((C1-99)/84,0)+2)*(MOD(TRUNC((C1-99)/84,0)+2-11,100)>2)+1),2)))

I now need the formula to calculate increments of 183 beginning at 21
not
98 like above. Would this work:?

=IF(C5="","",IF(C5<212,"1st",TRUNC((C5-212)/183,0)+2&MID("thstndrdth",MIN(9,2*RIGHT(TRUNC((C5-212)/183,0)+2)*(MOD(TRUNC((C5-212)/183,0)+2-11,100)>2)+1),2)))

This is a guess:
Yes.


Try it