•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Why is this formula not giving a value?
Our take
Are you puzzled by a formula that isn’t returning a value? You're not alone. The formula =ROUND(B1 - (0.05 * B1) + (0.03 * B2) may seem straightforward, but several factors can cause it to fail, including cell formatting issues and errors in referenced cells. The red border around the cell could signal an error, indicating that your data may need attention. Dive in to uncover specific reasons for this formula's behavior and learn how to resolve the issue effectively.
The formula is =ROUND(B1 - (0.05 *B1) + (0.03 * B2))
There is also a red border around the cell, for some reason. The cell format is 'General'.
Thanks in advance.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience