Please see the attached excel file.
I need to write and set formulae for the balance section (range C14 to E16). Each cell in this should have the difference between their corresponding cell value in 'Total' section and sum of corresponding cell value in 'segment A' and 'segment B'. That I have been able to do.
But an addition validation check is that the resultant difference should not be less than zero. For example if =C2-(C6+C10) results out be less than zero, then set C6 and C10 to blank.
Can this be done? Please help.