Mar 13 2021 10:16 AM
I need to bring info from other cells into a new cell inside of a statement.
I have attached a photo with a description of what im looking for.
Thanks
Mar 13 2021 10:50 AM
Mar 13 2021 10:59 AM
Mar 13 2021 11:10 AM
If the formula was
="Bought "&D43&" for "&F43
Excel would use the "bare" value of F43, and the result would be
Bought 5 for 197.01
TEXT(F43,"$#,##0.00") applies currency format to the value of F43, so that the result is
Bought 5 for $197.01