Average these only if this
I need help with this formula. I need the average of certain numbers for a certain apartment unit, so I currently have this formula: Average([Appliances],[Bath Cabinets],[Bath Countertops],[Door...
Forum Discussion
THAT WORKED!!! I have a follow up question. Just in case. Let's say I have two projects that are different from the rest. How would i do if project paradise hills 1, average this, if paradise hills 2, average this other, otherwise this.
Here is my attempt: Is this correct?
IF([Project Name] <> "Paradise Hills1",
Average([Appliances],[Bath Cabinets],[Bath Countertops],[Doors],[Flooring]),
IF([Project Name] <> "Paradise Hills2",
Average([Appliances],[Bath Cabinets],[Bath Countertops],[Doors]),
Average([Appliances],[Bath Cabinets],[Bath Countertops],[Doors],[Flooring],[Demo],[Kitchen Cabinets],[Kitchen Countertops],[Paint],[Door Hardware])
)
Here is my attempt: Is this correct?
IF([Project Name] <> "Paradise Hills1",
Average([Appliances],[Bath Cabinets],[Bath Countertops],[Doors],[Flooring]),
IF([Project Name] <> "Paradise Hills2",
Average([Appliances],[Bath Cabinets],[Bath Countertops],[Doors]),
Average([Appliances],[Bath Cabinets],[Bath Countertops],[Doors],[Flooring],[Demo],[Kitchen Cabinets],[Kitchen Countertops],[Paint],[Door Hardware])
)