Thread: Negative number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Negative number
Hello,

=CHAR(56.5-(SIGN(A2)+(A2=0))*8.5+RIGHT(A2,1))

I changed your request to make the task consistent: -10 will result in
"A", -1 in "B" ...

Regards,
Bernd

Reply With QuoteReply With Quote