Microsoft Office Questions? Ask a IT Expert for Support ASAP
How's it going.Let me read of your question. Give me a minute.
I'm overly frustrated. I've been trying to debug these formulas all day long. I'm finally giving up and hoping a fresh set of eyes can quickly see my error. I'm open to any options - i know there are several ways to go about finding the values.
its getting kind of late where I am and I would be happy to work with you tomorrow
Perhaps if you could provide a description of what you are trying to accomplish, what your goal is, perhaps there is a better way to achieve it.
It's a rounding issue.
Had to truncate column AD to 2 digits, otherwise match didn't see the same values to find a match. Look at the attached file.
I still have a question regarding column G. Your problem statement says if the value in F is equal to AE, but your function looks in AG
Did you mistype the formula or the question?
F should be looking to column AE. H should look to Ag and every other column thereafter should look to AG
Sorry, a better explanation:
The first level's $ paid out has to look at the total compensation payout of the initial level (AE) because they don't all start on the same level. Therefore, the first formula looks to column AE. All of the rest of the $ paid out columns look to column AG because it's always just a single level of compensation.
That solved it for me. Thank you so much! I corrected the error you pointed out and everything is perfect on the spreadsheet. Give me the prompt to rate your service. We're all done!
Glad to hear that fixed it. Thank you for letting me know.