Forum Discussion
calculation not working
I am using two populated fields to perform a simple multiplication formula and it won't calculate without me changing one of the cells to a hardcoded entry. Cell 1 =IF(J12>0,D16/E8,0) - D16 is $2...
I tried your method and still get the same error in Cell H17 (highlighted in Orange).
Not sure if I did this correct but here is the link: https://www.dropbox.com/scl/fi/xn7f3frk2j0y2aee0uu79/Test001.xlsx?dl=0&rlkey=hcxxgquz362at9hwzre2dla2w
If you format J12 as Number with 13 decimals, you'll see that its value is actually 32.1700000... instead of exactly 32. This causes the discrepancy.
So the result in H17 is correct if you take the real value of J12 into account.
If you need J12 to be a whole number for some reason, change the formula in that cell to
=IF(F12>0,ROUND(I12/F12,0),0)
- This did it. =IF(F12>0,ROUND(I12/F12,0),0)
Thank you!!