• 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


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

addition to a specific formula to deduct 1 pax each certain Number

Hany ali

Active Member
hello my masters, i want your help to amend for this formula



to can to deduct 1 pax each number of pax in Cell J1 Value
in the same items each Invoice
I mean for Example ,if I have in this invoice like more than 10 pax in
compact car … it should be deduct 1 pax each 10 pax( cell J1)


Last edited by a moderator:

Hany ali

Active Member
thanks alot my Dear... it's very Nice Array
but when i have for example in the same Invoice from the same item 33 pax ,it should to deduct 3 pax ,even in differant Rows in the Invoice


Last edited:


Excel Ninja
This additional requirement would require longer formula

In E3, copied down :