Help with number formatting on a cell with a number range (formula)

[EMY245]

Hi all,

I have a formula which pulls in a number range (e.g. 1000 - 2000) based a lookup, as below:

Salary: £15,000
Rating: 3

Recommended increase %: 1-3 (based on Lookup in table)
Recommended amount: 150-450 (calculation as 1% and 3% of the salary field).

Formula is:

=IFERROR(ROUND((VLOOKUP($A$1,RANGES,2,FALSE)*$D$7),0)&" - "&(ROUND((VLOOKUP($A$1,RANGES,3,FALSE)*D7),0)), "")

I want to be able to format the recommended amount range so that it shows as a currency value with comma to separate 1000s. However, nothing happens when I apply the usual number / currency formats. Any ideas?

Thanks!

 

[FormR]

Hi, something like this maybe..

=IFERROR(TEXT(ROUND((VLOOKUP($A$1,ranges,2,FALSE)*$D$7),0),"£#,##0")&" - "&TEXT(ROUND((VLOOKUP($A$1,ranges,3,FALSE)*D7),0),"£#,##0"), "")

 

[EMY245]

Spot on, thanks so much!