|Billable / Non-Billable||Electronic / Mail||Page Cost||search Fee Y/N||Search Fee||PDF||Postage||Total Billed|
|Billable||Electronic|| - ||Y||$10.00||$6.50||-||=$$|
|Non - Billable||Mail or electronic ||0||N||-||-||=$0|
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