ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula Suggestion (https://www.excelbanter.com/excel-worksheet-functions/242798-formula-suggestion.html)

Ward

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