Hi all,
I'm new on here, this has possibly been answered here already but I cant seem to find something that works for me.
I have an expenses sheet with a number of diff categories and sub categories, within some of these sub categories items are payable per no of times the task is completed.
We have an issue with one category with some people entering amounts in the total column which clearly don't relate to the approved amount payable per task/subcategory.
I have added a column which calculates the approved amount based on the information input.
I want to add a check that says if the category = x and amount in the total column = the approved amount then the return is blank/true but if the approved amounts don't match false/check calculation appears.
I have a basic IF formula in which is working for the calculations amount match but I think i need to nest it to allow for the other categories which is where I'm struggling.
My difficulty seems to be that some categories don't have a calculation validation as these are accommodations made on a case by case basis, So I need to say if the category = y or z then just return blank/true.
Sorry its probably a simply solution! I just cant seem to hit on it.
Thanks in advance for any advice
Bookmarks