Greetings, First let me thank you in advance with any help and/or suggestions on where I can start to figure out a solution. I have a project funds tracking sheet and am trying to determine the percentage of how much is over obligated based on estimates received and then had funds de-obligated and/or balanced out later in the process. The formula currently using is "=Difference/Max Funded" and shown as a percentage. But get the #DIV/0! For those that were cancelled and no funds were obligated (but I still have to track them as part of the greater project); but do have a column that show the status of Cancelled. Is it possible to have a formula that will show the overage as 0% if the status is "Cancelled" and if any other status it applies the formula above?
Again thank you for any help.
Again thank you for any help.