# How to Calculate the Percentage Increase from Zero in Excel – 4 Methods

## Basics of Percentage Increase

The formula to calculate percentage change is:

Change(%)=(Final Value-Initial Value)/Initial Value*100
Calculating the percentage increaseÂ from zero, means the initial value is zero.
Mathematically when we divide any number by zero, the result is undefined.

The percentage change is assumed as 100%. to calculate percentage increase from zero, here.

### Method 1 – How to Calculate the Percentage Increase from ZeroÂ  using IF Function in Excel

Use the IF function.

• Select D5. Enter the formula.
=IF(C4=0,1,C5/C4-1)

The logical test sets the initial value (C4) to zero. If the statement is TRUE, the output will be 1, which is 100%. Otherwise, Excel will return the percentage increase following the percentage change formula.

• Press ENTER. The change in Revenue is displayed.

Since, C4 <> 0, Excel returns -1 by calculating \$(0.00/1348.00)-1.

• Convert the number into a percentage
• Go to theÂ HomeÂ tab and select Number.
• Select the PercentageÂ (%)Â sign.

Excel will convert the number into a percentage.

Note:
There’s no change in the percentage for January, because there’s no previous dataÂ to compare with.

### Method 2 – How to Calculate the Percentage Increase from Zero using the SIGN Function in ExcelÂ

• Select D5. Enter the formula.
=IF(C4=0,SIGN(C5),C5/C4-1)

The logical test is C4=0. If the statement is TRUE, Excel will return the result of SIGN(C5). If the statement is FALSE, Excel will return the output by calculating C5/C4-1 to get the percentage increase.

Formula Breakdown

SIGN(C5) âŸ¶ returns the result to represent the sign of the number in C5.
Â  Â  Â  Â  Output âŸ¶ 0
C5/C4-1 âŸ¶ calculates the increase in Revenue.
Â  Â  Â  Â  Output âŸ¶ -1
IF(C4=0,SIGN(C5),C5/C4-1) âž¡Â  returns the result by analyzing the logical test.
Â  Â  IF(C4=0,0,-1)
Â  Â  IF(FALSE,0,-1)
Â  Â  Â  Â  Output âž¡ -1

• Press ENTER to see the result.

Excel returnsÂ  -1, because C4 is \$1348.00. The statement C4=0 is FALSE. The output of C5/C4-1 is returned.

### Method 3 – Calculating the Percentage Increase from Zero using the AND Function in Excel

Use the AND function.

• Select D5. Enter the formula.
=IF(AND(C4=0,(C5-C4)<>0),1,C5/C4-1)

The logical test is AND(C4=0,(C5-C4)<>0). If the statement is TRUE, Excel will return 1 as output. If the statement is FALSE, Excel will return the output by calculating C5/C4-1 to get the increase in Revenue.

Formula Breakdown

C5-C4 â†’ Subtracts C4 from C5.
Â  Â  Â  Â  Output: -12
C5/C4-1 â‡’ Calculates the change in Revenue.
Â  Â  Â  Â  Output: -0.008902077
AND(C4=0,(C5-C4)<>0) â†’ Checks if all arguments (C4=0 and C5-C4<>0) are TRUE. Returns TRUE if all the arguments are TRUE. Otherwise,Â FALSE.
Â  Â  AND(C4=0,(-12)<>0)
Â  Â  Â  Â  Output: FALSE (the first argument is FALSE)
IF(AND(C4=0,(C5-C4)<>0),1,C5/C4-1) â‡’ Returns the result after analyzing the logical test.
Â  Â  IF(AND(C4=0,(C5-C4)<>0),1,-0.008902077)
Â  Â  IF(FALSE,1,-0.008902077)
Â  Â  Â  Â  Output: -0.008902077

• Press ENTER. Excel will returnÂ  -0.008902077.

### Method 4 – Calculating the Percentage Increase from Zero using the ISERROR Function in Excel

• Select D5. Enter the formula.
=IF(ISERROR((C5-C4)/C4),1,(C5-C4)/C4)
The logical test is ISERROR((C5-C4)/C4. If the statement is TRUE, Excel will return 1 as output. If the statement is FALSE, Excel will return the output by calculating (C5-C4)/C4 to get the percentage increase.

Formula Breakdown

(C5-C4)/C4 â‡’ calculates the change in Revenue.
Â  Â  Â  Â  Output : -1
ISERROR((C5-C4)/C4) â†’Â  checks whether (C5-C4)/C4 is an error. Returns TRUE if it is an error, FALSE if it is not.
Â  Â  Â  Â  Output: FALSE (since –1 is not undefined or has any other error)
IF(ISERROR((C5-C4)/C4),1,(C5-C4)/C4) â‡¾ returns the result by analyzing the logical test.
Â  Â  IF((ISERROR((C5-C4)/C4),1,-1)
Â  Â  IF(FALSE,1,-1)
Â  Â  Â  Â  Output: -1

• Now press ENTER. The final output is -1.

## Practice Workbook

Practice here.

Practice Workbook

Practice using this dataset.

## Related Articles

<< Go Back to Percentage Change |Â Calculating PercentagesÂ | Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF