• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Correcting the equation preventing the entry of any quantity for a particular item as long as the remaining balance is equal to 5

Hany ali

Active Member
Hello My Dear ,I Want Correcting the equation preventing the entry of any quantity for a particular item as long as the remaining balance is equal to 5 From Data Validation
In Column B From Input Sheet
Code:
=IF(SUMIF(Main!$B:$B,$A2,Main!$F:$F)<=5,"",IF(SUMIF(Main!$B:$B,$A2,Main!$F:$F)-5>=5,$F2-5,$B2))
because i Want To PREVENT Any Quantity For Any Items if it Balance = 5
 

Attachments

  • Store.xlsx
    28 KB · Views: 5
  • Untitled.png
    Untitled.png
    42.3 KB · Views: 17
Back
Top