Forum Discussion
multiplication formula not working
Morning, I am calculating a portion of funds to be distributed using a dollar amount and a percent. My formula in the cell is: =B12*J10 B12 = $996,563.00 J10 = 10.04% The correct answer using...
Detlef_LewinThank you for that, it seems like that is the issue. The 10.04 is being calculated from another formula in the sheet and I set the format to show 2 places. How do I get it to use the 10.04 and not the 10.039747?
Thanks
Use ROUND() or any other rounding function.
- That worked, thanks for your help.