Forum Discussion
IFS, ANDS HELP
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....
Hia,
I've had a look at the spreadsheet that you attached and 'fixed it' for you :)
I've written a few notes on there that hopefully point you in the right direction as far as understanding the formulas. You should find it pretty flexible as far as adding or removing people and jobs goes, just watch out for the column headings of the rate table, they must match exactly the name of the job.
- Phillip,
This is so helpful and I really appreciate the time you have spent trying to help me, and I also appreciate the "teaching" insight and instructions you have included with the spreadsheet you sent to me.
Lord Bless Ya Bunches, I would not have been able to do this without your help!!!!!!!!!!
Hi Phillip, THANKS THANKS THANKS A MILLION
Hia,
I wouldn't post your phone number publicly here.. who knows where it will end up.
I'll have a look at the spreadsheet you posted today and get back to you.