$ SIGN WITH FORMULA
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
"Stefi" wrote:
Why don't you use simply =IF(E7="A",510.09,604.96) and format the result cell
as Currency?
Regards,
Stefi
€˛LostNFound€¯ ezt Ć*rta:
I HAVE GOTTEN THE FORMULA TO WORK BUT WOULD LIKE TO ADD THE $ SIGN IN FRONT
OF THE ANSWER SINCE IT REPRESENTS A DOLLAR AMOUNT
=CONCATENATE(IF(E7="A",510.09,""),IF(E7="B",604.96 ,"")
|