View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Formula suggestions

Hello,

If Iunderstand you correctly:
=IF(A1<99,"1st",IF(A17574,"Older",ROUNDUP((A1-14)/84,0)&MID
("thstndrdth",MIN(9,2*RIGHT(ROUNDUP((A1-14)/84,0))*(MOD(ROUNDUP
((A1-14)/84,0)-11,100)2)+1),2)))

And if this is correct, the credit for the ordinal part belongs to
Rick Rothstein:
http://groups.google.de/group/micros...70e52 ba21036

Regards,
Bernd