This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am trying to clean up an old spreadsheet that has become riddled with errors over the years. Do not want to start over, just correct as needed. One of the formulas that is to determine % of change between current year YTD and prior YTD, starts with "1+" and I cannot find anywhere what that is. It appears to me it is probably left over from an old version or old program, as it seems to be skewing my data, but would like to be sure before making changes. This is how the formula shows:
=1+(ROUND(IF(K23=0, IF(L23=0, 0, SIGN(-L23)), IF(L23=0, SIGN(K23), (K23-L23)/L23)),5)) Anyone know what the "1+" ?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
The 1+ is there because of the use of (K23-L23)/L23 instead of just K23/L23 - they apparently didn't want the % change, just the % and didn't understand the math.
Try replacing that long formula with just
=IFERROR(K23/L23,"No old data")