## Basics of Percentage Increase

The formula to calculate percentage change is:

`Change(%)=(Final Value-Initial Value)/Initial Value*100`

**Â**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.

- Drag down the
**Fill Handle**to**AutoFill**the formula.

**Note:**

There’s no change in the percentage for

*January,*because there’s no previous data

*Â*to compare with.

**Read More:** How to Calculate Percentage Decrease in Excel

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

Use **the SIGN function**.

- 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.

- Convert the number into a percentage following the steps described in
**Method 1**. - Drag down the
**Fill Handle**to**AutoFill**the formula.

**Read More: **How to Calculate Average Percentage Increase in Excel

### 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*.

- Convert the number into a percentage following the steps described in
**Method 1**. - Drag down the
**Fill Handle**to**AutoFill**the formula.

**Read More:** How Do You Calculate Percentage Increase or Decrease in Excel

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

Use **the ISERROR function**.

- Select
**D5**. Enter the formula.

`=IF(ISERROR((C5-C4)/C4),1,(C5-C4)/C4)`

**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*.

- Convert the number into a percentage following the steps described in
**Method 1**. - Drag down the
**Fill Handle**to**AutoFill**the formula.

**Read More: **Calculate Average Percentage Increase for Marks in Excel Formula

## Practice Workbook

Practice here.

**Practice Workbook**

Practice using this dataset.

**Related Articles**

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