Saturday, April 8, 2017

yogi_Split Expenses By Participants

Google Spreadsheet   Post  #2147
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-08-2017
I'm trying to create a sheet for shared expenses and am want to break down the expense by those involved.  I would like to have the following results.


Column F
If column E contains "WDG" then column F = column D/3
If column E contains "WD" then column F = column D/2
If column E contains "WG" then column F = column D/2

Column G
If column E contains "WDG" then column G = column D/3
If column E contains "WD" then column G = column D/2
If column E contains "WG" then column G = blank

Column H
If column E contains "WDG" then column H = column D/3
If column E contains "WD" then column H = blank
If column E contains "WG" then column H = column D/2

I would also like for the total row to float down as I add expenses.

Don't know if I am using the correct function.



https://docs.google.com/spreadsheets/d/1ePVdZrzWm7ShXSu4HE6iUWwf5Cj0QwImM4OLiuKaeaE/edit?usp=sharing