Hi,
Thanks for any help I am trying to get a formula that will deduct agents & depot commissions from the total sales based on a Y for yes commission to be paid or N no commission to be paid.
I have attached a table with an example, i did think of the if function but cant figure it out.
Many thanks for any help
Bookmarks