View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MivPiv
 
Posts: n/a
Default "translate" numbers into words

I have one column which contains cost numbers. Column E.
I would like to automatically "translate" the cost number into a word in the
next cell in columnF

I hvave tried to do like this =IF(E20=300015;"Staff Cost") and that of
course works. But what do I do when I have 30-50 differetn numbers to choose
from. i have tried to put more "IF's" in there and just continue the formula
for each number/word - but that doesnt seem to help.

I appreciate any help I can get on this
Best regards,
Miv