• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

ROMAN formula error

V

vaidmohammed

Member
I am using ROMAN() formula in one of my formula. While converting number 4000 into ROMAN MS Excel 2013 is giving #VALUE!

The formula which I am using is : -

=CONCATENATE((ROMAN(COUNTA($P$6 : P4005)))," - ",P4005)

Till 3999 it is working fine and giving roman number but from 4000 it is giving the above error.

Please help.
 
Hi ,

Have you checked the Excel help on this function ?

What kind of help are you expecting from this forum ?

Narayan
 
Hi ,

What kind of solution do you want ? Formula or VBA ?

What is the upper limit as far as the number to be converted goes ? Is it only 4000 or is it 40,000 or 400,000 or ... ?

Narayan
 
Hi,

You can use any number between 1 and 3999. (Romans apparently never worked with numbers outside this range.)
 
Hi ,

The principle behind the Roman numbering system is that you cannot have more than 3 consecutive symbols that are identical ; however numbers greater than 3999 can be represented by using the multiplier bar ; a bar above a symbol means the symbol is multiplied by 1000.

Thus 5000 would be represented by the letter V with a bar on top.

4000 would thus be represented by MVbar , where Vbar represents the letter V with the bar on top.

Unfortunately , given that I do not know whether this is possible using a font , I am not in a position to help. Sorry.

Narayan
 
Below is valid from 1 to 9999999

=REPT("M",TRUNC(A3/1000))&ROMAN(SUBSTITUTE(A3-TRUNC(A3/1000)*1000,".",""))
 
You must log in or register to reply here.
Back
Top