Cicely2011
New Member
- Joined
- May 6, 2017
- Messages
- 1
I am using the following formulas, but I cannot figure out how to get my result to include a dollar sign and commas to appear as currency. Can someone show me where I need to put edits?
=CONCATENATE("You want to make $",ROUND($D$7/($D$8/12),0), " per year?")
Currently producing: You want to make $500000 per year?
=CONCATENATE("You need to make ",ROUND(D7/D8,0)," per month")
Currently producing: You need to make 41667 per month.
=CONCATENATE("That's about ",ROUND(D7/D8/30,0)," per day")
Currently producing: That's about 1389 per day.
I need them to say You want to make $500,000 per year? You need to make $41,667 per month. That's about $1,389 per day.
=CONCATENATE("You want to make $",ROUND($D$7/($D$8/12),0), " per year?")
Currently producing: You want to make $500000 per year?
=CONCATENATE("You need to make ",ROUND(D7/D8,0)," per month")
Currently producing: You need to make 41667 per month.
=CONCATENATE("That's about ",ROUND(D7/D8/30,0)," per day")
Currently producing: That's about 1389 per day.
I need them to say You want to make $500,000 per year? You need to make $41,667 per month. That's about $1,389 per day.