Forum Discussion
IFS, ANDS HELP
Can you have a table of names/jobs/rates/billed rates to look up against?
If you can, you could use an 'index match match' to check find the details you are looking for.
I've attached a copy of it working, I think this is what you are trying to do. If it is and you need more of an explanation how let me know.
Phillip,
Thanks so very much, I like the idea you have but I thought it would be best to better explain to you what I am attempting to actually do, so if you want to look at the 3 attachments I am including that would be quite wonderful. However, please know if it isn't something you can bother with, I understand completely. I have screen shots of what I am working on attached.
I do billing for subcontractors who don't want to deal with invoices and so I have a List of the Person (subcontractors) and their job sites (they all work together in a sort of co-op of jobs helping each other and the home owners pay them depending on what they are doing). I just have different pay rates and billing rates b/c that is how they pay me is the Mark UPs on both the rates and materials). Thanks again in advance! Take good care!
Can you attach a copy of the spreadsheet to play with?
You can do what you are trying to do, the way you are trying to do it but you would need to have a nested IF per site, which is going to very quickly become unmanageable. It would look something like this (i'm on my phone so it wont look exactly like this :D )
if(b2="fritcsh",if(c2="rick",54,if(c2="john",28)),if(b2="boseth",if(c2="rick",54,if(c2="john",28)),"unknown")
Do the rates change depending on the job? or does everyone have a rate that they change?
The invoice is per site per contractor? or just per site where all the costs are added up no matter who did the work?
oh sure that would be better so you can "see" the actual spreadsheet, so I will attach it, I am not going to worry about the receipt text or invoicing sections and don't want to burden you with that, so we can just figure out how to make this situation function and I will go from there. Thanks so much for all of your help and efforts!! Its been a head against bricks problem for me for a couple of weeks but I sure am learning things non the less....
