Forum Discussion
swapnilbawane
Apr 02, 2024Copper Contributor
How to add currency values in microsoft excel?
I was testing to add currency values in dollar currency and did not get proper results? What is the reason and how do you solve this? $10,000 $20,000 $0.00 `=SUM(I25:I26) You...
Detlef_Lewin
Apr 02, 2024Silver Contributor
swapnilbawane
Apr 03, 2024Copper Contributor
You are right. I tried to format the cell to number or currency still it gives text as TRUE value for ISTEXT. Why is this? What am I missing out and please provide a solution to add currency values. I am using Microsoft Excel 2013 edition.
- Detlef_LewinApr 03, 2024Silver Contributor