![]() |
Formula Suggestion
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))) |
All times are GMT +1. The time now is 11:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com