I am trying to find a specific string of code that would work for the following situation:
In simplest terms, I need a code that will produce a 0.00% percentage increase from 0.00% to 0.00%, but ALSO a 100.00% increase from 0.00% to any higher percentage (like 45.67%). I am trying to use IF, ISERROR, and OR commands but I cannot figure it out. I will attach a picture for reference.
An example of what I mean is the code I have written in cell C26 (=IF(ISERROR((C6-B6)/B6),1,(C6-B6)/B6)). This cell depends on the percentage increase from cell B6 to C6, but I have it programmed to produce a 100.00% if the statement is true. This is where I run into the problem. I want that cell to produce a 0.00%. At the same time, I want to be able to apply the exact same code to cell D27, which depends on the percentage increase from cell C6 to D6, which I want to be 100.00%. I do not want #DIV/0 errors (hence the IFERROR command).
Please help me if you can.
Thanks so much
In simplest terms, I need a code that will produce a 0.00% percentage increase from 0.00% to 0.00%, but ALSO a 100.00% increase from 0.00% to any higher percentage (like 45.67%). I am trying to use IF, ISERROR, and OR commands but I cannot figure it out. I will attach a picture for reference.
An example of what I mean is the code I have written in cell C26 (=IF(ISERROR((C6-B6)/B6),1,(C6-B6)/B6)). This cell depends on the percentage increase from cell B6 to C6, but I have it programmed to produce a 100.00% if the statement is true. This is where I run into the problem. I want that cell to produce a 0.00%. At the same time, I want to be able to apply the exact same code to cell D27, which depends on the percentage increase from cell C6 to D6, which I want to be 100.00%. I do not want #DIV/0 errors (hence the IFERROR command).
Please help me if you can.
Thanks so much