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

question by Tweedle:

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/28zV7XRlYE4;context-place=forum/docs
If then function

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