Solved

# Converting Amounts In Excel

Posted on 2014-02-08
142 Views
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
Question by:PipMic
• 2

LVL 49

Accepted Solution

Rgonzo1971 earned 300 total points
ID: 39844007
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"))
``````
Regards
NumbersLetters.xlsx
0

LVL 49

Assisted Solution

Rgonzo1971 earned 300 total points
ID: 39844149
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"))
``````

Regards
NumbersCapitalLetters.xlsx
0

Author Closing Comment

ID: 39846994
Thanks, it works a treat
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.