How to simplify formula

Hi Expert

How to simplify formula in Inflow tab, column B.

The formula are quite long and complex.

I believe excel should be intelligent enough to simplify this