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
try this
IF([Project Name] <> "Paradise Hills",
Average([Appliances],[Bath Cabinets],[Bath Countertops],[Doors],[Flooring],[Demo],[Kitchen Cabinets],[Kitchen Countertops],[Paint],[Door Hardware],[Tub Completion %]),
Average([Appliances],[Bath Cabinets],[Bath Countertops],[Doors],[Flooring],[Demo],[Kitchen Cabinets],[Kitchen Countertops],[Paint],[Door Hardware])
)
IF([Project Name] <> "Paradise Hills",
Average([Appliances],[Bath Cabinets],[Bath Countertops],[Doors],[Flooring],[Demo],[Kitchen Cabinets],[Kitchen Countertops],[Paint],[Door Hardware],[Tub Completion %]),
Average([Appliances],[Bath Cabinets],[Bath Countertops],[Doors],[Flooring],[Demo],[Kitchen Cabinets],[Kitchen Countertops],[Paint],[Door Hardware])
)