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 advance
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.
Thank You Mr. Sergei for your usual support
Hussein_Mohamed , you are welcome
