Divide if value is 0

[xKidz]

https://imgur.com/gYDlsNh

Hi,

I have a big excel list with over 2000 lines
I would like

that whenever a line's value is zero ("Final Cost column") to divide the number from above that is not zero by the number of duplicates ("Extra line count in my case").

 

[Finalfight40]

Does this work? Entered in C2 (Based on your table being columns A, B, C)

=IF(A2=0, C1, IF(A3=0, A2/B2, A2))

 

[xKidz]

Does this work? Entered in C2 (Based on your table being columns A, B, C)

=IF(A2=0, C1, IF(A3=0, A2/B2, A2))

Works perfectly, thank you