IF Function with multiple true values

klambie0420

New member
Joined
Jul 10, 2013
Messages
1
Reaction score
0
Points
0
Okay so here is my problem. I have a sheet(SHEET 1) that is filled out with amounts, depending on who owes what for a certain bill. In the notes section, Column E, I want it to fill text if there is an amount>0 in Columns C-D using information pulled from the database on a separate sheet(SHEET 2). I know how to pull the text if only one of the columns (B-D) is greater than zero, but I do not know how to have it fill multiple text values into one cell. For example, in row two, I would like the notes field to autofill as "Joe Schmoe, Garey Busey, Company"


SHEET 1
Property ID(A) Homeowner Amount(B) Tenant Amount(C) Company Amount(D) Notes(E)
street1234 $ 10.00 $ 15.00 $ 12.00
lane12 $ 9.00 $ 13.00 $ 36.00
avenue3 $ 9.99 $ - $ -
parkway68 $ 7.20 $ - $ 40.00

SHEET 2
Property ID(A)Tenant Name(B)Home Owner Name(C)
street1234Joe SchmoeGary Busey
lane12John SmithJohn Doe
avenue3Jane DoMr. Anderson
parkway68Jeff SmithJoey Homeowner
 
Top