Forum Discussion
formula assist
Dears, could you please assist regarding the attached sheet as i need to update the formula in the highlighted cells to be automated formulas instead of the current manual formulas. Thanks in ad...
If I understood the logic correctly that could be
=IF($C4="Inst", $D4-$F4, IF($C4="Main", IF($F4=0, $D4-$F4, -$F4), 0 ) )and
=IF($C4="Inst", -$G4, IF($C4="Main", IF($F4=0, -$G4, -$D4), 0 ) )
If I understood the logic correctly that could be
=IF($C4="Inst", $D4-$F4, IF($C4="Main", IF($F4=0, $D4-$F4, -$F4), 0 ) )and
=IF($C4="Inst", -$G4, IF($C4="Main", IF($F4=0, -$G4, -$D4), 0 ) )
Thank you so much for the solution.
