Dear community,
May i know how can we derive the output as per screenshot below and i have attached the working file ( formula included) for your reference.
Basically, i want to deduct each column of Input 2 from Input 1 in order to derive the balance amount. Lastly, i would like to know how do we do the tagging for the status - If the amount is positive, put as "yes" , if amount is negative and it is first negative amount being show, put as "No", if the amount is negative but it is following after the first negative amount , put as "NA"
Appreciate if you could adivse me on this.
Solved! Go to Solution.
May i know how about if the value shown as below ?
May i know if there is way to make the formula more dynamic?
Thank you.