Forum Discussion

Copper Contributor

Oct 08, 2019

Delta % calculation

Can anybody help me im desperate!! column A1 has a total 1500 column A2 is 0 column A3 is the delta (1500 - 0) column A4 shows the percentage as #DIV/0! cannot remember how this formula works...

excel

tauqeeracma

Iron Contributor

Oct 08, 2019

HIJHill69

Delta function in excel, basically tests whether two values are equal. It returns 1 if both values are equal and returns 0 otherwise.

If you want to just compare values in A1 & A3 you can use =DELTA(A3,A1) or elaborate your requirements with example in excel sheet.

Thanks

Tauqeer

JHill69

Copper Contributor

Oct 08, 2019

Hello tauqeeracma

i already got the delta thank you, i need to undertsand how to correctly formulate the % of the delta without getting the DIV/0 error when 1 cell is on zero

can you help me?