Need excel formula figured out

  • Status: Closed
  • Prize: $20
  • Entries Received: 11
  • Winner: elqueabandona

Contest Brief

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

Recommended Skills

Top entries from this contest

View More Entries

Public Clarification Board

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!