For anyone looking for an answer or facing the same problem. Do the following things to resolve the issue
If your values are a result of other functionscheck if the formulas for these functions still hold true, if not correct them
try recreating the same formula in different parts of the worksheet/workbook, if the formula works then error is isolated to the cell where you are getting the results
Try with static values in the formula instead of dynamic, if the problem still pertains then issue is with the cell
** Check the format of the cell** Change it to number format
** Check whether the calculations for the sheet/workbook are set to automatic instead of manual**
These steps should help you isolate the problem to a certain degree Thanks to @Rory & @MayukhBhattacharya for helping me figure out how to sort this issue
发布评论
评论（1）
对于任何寻求答案或面临同样问题的人。执行以下操作来解决问题
这些步骤应该可以帮助您在一定程度上隔离问题
感谢@Rory & @MayukhBhattacharya 帮助我弄清楚如何解决这个问题
For anyone looking for an answer or facing the same problem. Do the following things to resolve the issue
These steps should help you isolate the problem to a certain degree
Thanks to @Rory & @MayukhBhattacharya for helping me figure out how to sort this issue