Billable / Non-Billable | Electronic / Mail | Page Cost | search Fee Y/N | Search Fee | PDF | Postage | Total Billed |
Billable | Mail | $$ | Y | $10.00 | $6.50 | $$ | =$$ |
Billable | Electronic | - | Y | $10.00 | $6.50 | - | =$$ |
Non - Billable | Mail or electronic | 0 | N | - | - | =$0 | |
Non- Billable | Mail | 0 | Y | 10.00 | 0 | $10.00 |
<tbody>
</tbody>
Please let me know if I am thinking correctly or if I am totally wrong. below is what I am trying to make happen and I am with the limited excel knowledge I have, I am thinking my only logical way is to do a nesting IF but this will most likely be the longest IF in history lol and I am not sure if I can pull it off or if it will even work.
If A2 is billable and B2 is Mail and D2 is Y , then I need H2 = C2+E2+G2
If A2 is Billable and B2 is electronic and D2 is Y, Then I need H2 = E2 + F2
If A2 is Non-Billable and D2 is N, then H2 = 0
If A2 is Non-Billable and D2 is Y, then H2 = 10
Please advise