Try this =IF(D3<(B3*0.5),"LIMITED STOCK","STOCK OK")
Hi Paul I don't see anything wrong and have no idea why it is not working unless you copied the codes to the wrong worksheet module. You can add...
Hi emily I don't think that is possible with running total. Sunny
Hi Chris See if this helps. The dates are auto calculated. You only need to change the product to filter. Enter an asterisk for all products. Su...
Hi Paul If you can attach your codes it would help. Sunny
Hi Paul Without seeing your file, I can only make a guess. Some of the possibilities are: 1) You did not change the codes correctly. 2) You c...
Hi Paul I have modified Philip's code for you. I have unmerged the cells F4 and F5 as merged cells can cause unexpected problems. I would sug...
Hi Dritan Maybe you can give this a try.
Hi Emily Select any cell in column A of your PivotTable and then from the ribbon select PivotTable Tools - Options - Collapse Entire Field This ...
Hi Rona I would normally use a VLOOKUP in a situation like this. Since you wanted an IF formula, I have attached a sample containing both VLOOKU...
Thanks for your feedback. Glad that we could help. I am also happy to see that more members are willing to contribute their ideas and solutions to ...
Hi Chris I have redone everything using a Pivot Table. The only disadvantage is you cannot show the monthly total together with the week total. ...
Hi Chris You can try using a PivotTable to create a PivotChart. Refer attachment. Sunny
Hi Ward Thank you for your feedback and good luck with your search. Sunny
Hello Dritan If you want to use the formula suggested by Anders, I suggest you use SEARCH instead of FIND as SEARCH is not case-sensitive. Sunny