Dec 10 2021 01:52 AM
need help with a worksheet used to work out commission earnt. It has columns where if it contains yes then its value A and then columns where if it contains 1yr its one amount or 2 yr then its another. also are columns where it has figures that a percentage is earnt, ie 10% of £1000
Dec 10 2021 01:56 AM - edited Dec 10 2021 01:58 AM
I saw the file but I didn't understand it.
Would be something like
=SUM(E29*(1.1))
???
Dec 10 2021 02:02 AM
Dec 10 2021 04:44 AM
@stuart395 Calculating with numbers is so much easier than with texts. If you would add the various rates above each column and use 1 for Yes, 0 for No and the the number 1 or 2 for the years of warranty, you can use a simple SUMPRODUCT formula as demonstrated in the attached file. By the way, I don't really understand the purpose of the two bottom rows in the table, but that's for you to judge, of course.