Need excel formula figured out

• Статус: Closed
• Винагорода: $20
• Надіслані роботи: 11
• Переможець: elqueabandona

Winner

Стисле описання конкурсу

I have a spreadsheet that I can't figure out how to make a formula for.

Video explainer attached as well as excel spreadsheet.

Basically, I need the formula to:

Look at 3 cells
If value in any of the cells is greater than 0
Multiply by "Rental Comps" based on: field value (1 bed, 2 bed, or 3 bed), and zip code
If value is greater than zero in multiple cells, multiply values THEN add them together

See video for more explanation

https://revamp365.sharepoint.com/:f:/g/EsDIOuOI65tEjeYcLdhOKKwB8hjES4FqhNFBLIIdDNDSbQ?e=sp1Sud

First entry with the formula correct and working will get awarded

Рекомендовані навички

• Введення даних
• Обробка даних
• Excel
• Sharepoint
• Visual Basic