"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
|