If Column A multiple by column B = 0; then sum children

Skelet deSign

Could you help me with this formula?

Skelet deSign

Thank you this works for me

=IF([Column A]@row * [Column B]@row = 0, SUM(CHILDREN()),[Column A]@row * [Column B]@row)

bisaacs

Hey @Skelet deSign,

You'd want to use a formula like this:

=IF([Column A]@row * [Column B]@row = 0, SUM(CHILDREN()), "0")

Hope this helps!

Skelet deSign

Thank you this works for me

=IF([Column A]@row * [Column B]@row = 0, SUM(CHILDREN()),[Column A]@row * [Column B]@row)