• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 157
  • Last Modified:

Converting Amounts In Excel

Hi all,

Grateful if someone would assist on this problem:

I am trying to automate the conversion an amount and break it up into several constituents, [Using MS Excel 2003-7]

Amount      100000      10000      1000      100        10            Unit
£545.00       ***         ***       ***              FIVE        FOUR      FIVE
£5,886.32 ***          ***      FIVE              EIGHT      EIGHT       SIX
£3,527.07 ***                ***      THREE      FIVE         TWO              SEVEN

The idea being that when I enter the amount the breakdown happens automatically across the cells.

Thanks
0
PipMic
Asked:
PipMic
  • 2
2 Solutions
 
Rgonzo1971Commented:
Hi,

pls try

=IF($A8<B$7,"***",CHOOSE(MOD(INT($A8/B$7),10)+1,"zero","one","two","three","four","five","six","seven","eight","nine"))

Open in new window

Regards
NumbersLetters.xlsx
0
 
Rgonzo1971Commented:
Hi,

with Capital Letters
=IF($A3<B$2,"***",CHOOSE(MOD($A3/B$2,10)+1,"ZERO","ONE","TWO","THREE","FOUR","FIVE","SIX","SEVEN","EIGHT","NINE"))

Open in new window


Regards
NumbersCapitalLetters.xlsx
0
 
PipMicAuthor Commented:
Thanks, it works a treat
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now