For some financial analysis I do, in some excel cells, I desire that the output end-result always report as $ zero. It is purposefully desired, very intentionally, that certain cells equate to the amount $ 0.00, in the end, no matter what is in that cell for formula. A math equation in the cell is necessary; I can't leave the cells blank or just the actual number of " 0 ". This is so that reviewers can see there is work done and know that I consider the right amounts and where they come from.
There has been a previous solution, but it is tedious to do and it is neither efficient nor 100% effective, so that is why I am on this forum. For explain that, I get the feed-in of the excel and financial data given to me by a coworker. In the excel given to me, inside one of the excel cells, there has been this formula : =R21*R22 . I cannot delete what is already there; I must continue to have those remain. Using other data from other cells and other sources, that math equation for those two equals to an amount of (negative) -19.3 . The no-longer-desired way of how I've solved this problem, is just simply I add 19.3 to it, so the formula becomes =R21*R22+19.3 . It is then $ zero. However, sometimes, after I do that, I make further other adjustments that affect R21 and/or R22. After those other adjustments having been made, it turns-out that there is an amount - something other than $ 0.00. This is infuriating because I had already made $ zero. Sometimes I forget then adjust it again, and I submit it wrongly. An amount there, any amount, is un-desired. So I ask for help on this forum, is there some sophisticated excel formula I can add to after the =R21*R22 part that will *always* make it $ zero?
There has been a previous solution, but it is tedious to do and it is neither efficient nor 100% effective, so that is why I am on this forum. For explain that, I get the feed-in of the excel and financial data given to me by a coworker. In the excel given to me, inside one of the excel cells, there has been this formula : =R21*R22 . I cannot delete what is already there; I must continue to have those remain. Using other data from other cells and other sources, that math equation for those two equals to an amount of (negative) -19.3 . The no-longer-desired way of how I've solved this problem, is just simply I add 19.3 to it, so the formula becomes =R21*R22+19.3 . It is then $ zero. However, sometimes, after I do that, I make further other adjustments that affect R21 and/or R22. After those other adjustments having been made, it turns-out that there is an amount - something other than $ 0.00. This is infuriating because I had already made $ zero. Sometimes I forget then adjust it again, and I submit it wrongly. An amount there, any amount, is un-desired. So I ask for help on this forum, is there some sophisticated excel formula I can add to after the =R21*R22 part that will *always* make it $ zero?
