If you don't mind the number returned as text,
then: =TEXT(formula,"$#,##0.00") would achieve the result
So you could try:
=TEXT(CONCATENATE(IF(D7="A",510.09,""),IF(D7="B",6 04.96,""),IF(D7="C",672.093,""),IF(D7="D",740.74," "),IF(D7="E",808.69,""),IF(D7="F",869.1,""),IF(D7= "I",1069.69,"")),"$#,##0.00")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"LostNFound" wrote:
The formula string is a little longer than I put and the letters are not
sequential
=CONCATENATE(IF(D7="A",510.09,""),IF(D7="B",604.96 ,""),IF(D7="C",672.093,""),IF(D7="D",740.74,""),IF (D7="E",808.69,""),IF(D7="F",869.10,""),IF(D7="I", 1069.69,""))
I tried to format this cell as currency and two deimal places but do not get
$$ and also the section with 869.10 returns only 869.1