Hi,
I have been following instructions found on a website for developing an MRP system which up until now has been great. However I have come unstuck with the following formula =IF(RIGHT(B2,5)="Total",0,G1+F2-E2) this code is placed in G2 in the following example. I need help understanding what each part of the formula does so I can adapt it for my own spreadsheet.
Any help would be greatly appreciated.
Screenshot 2018-02-22 at 18.28.30.png
Bookmarks