Hello,
I'm not an expert Excel user, so am struggling with a sum. Any help would be much appreciated!
Basically, I want the user to only have to enter data in column E (In Stock) - when they fill this in, the spreadsheet will work out how many items to order in column F { =MAX(0,C2-E2) }. The spreadsheet will then also work out the order values in column G { =F2*B2 }.
However, if column E is left blank I don't want any values to show in either F or G, as it is currently displaying the maximum values in each. Does anybody know the formula that would solve this issue?
Many thanks!
Bookmarks