Division in excel

[ridwanr]

Hi all,

Am looking for an excel formula in which if the Cost Pub is 0 then return the figures to total cost.

See attached file for better understanding.

Thanking you for your help in advance.

Regards,
Ridwan

 

[vletm]

ridwanr
Eg for cell E5 =IFERROR(C5/B5,C5)

 

[Hui]

=If(C5=0, C5, C5/B5)