• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. N

    Finding the best option

    Here is what I am trying to do. I have some land that I want to build 6 rental properties on it that will maximize my rental income. I have 5 different homes I can choose from and each have different rental amounts. I could choose the home that would give the most rent and build 6 of those...
  2. N

    Max Formula Issue... At least I think it is a max formula issue?

    I am not sure if I did it right. Here is the formula {=MIN(IF((Sheet1!$B$4:$B$100>=1099)*(Sheet1!$B$4:$B$100<=0),Sheet1!$C$4:$C$100,1000000000))}. When I enter the 1E9 it becomes 1000000000 and the answer is 1000000000 in the cell. Sorry I am an idiot.
  3. N

    Max Formula Issue... At least I think it is a max formula issue?

    I did read it thank you. Now I assume that if I wanted to find the minimum from the same column the formula would be [=MIN(IF((Sheet1!$B$4:$B$100>=1099)*(Sheet1!$B$4:$B$100<=0),Sheet1!$C$4:$C$100,0))} but it does not work. Is there another trick I do not know?
  4. N

    Max Formula Issue... At least I think it is a max formula issue?

    It worked thanks. What does "*" mean?
  5. N

    Max Formula Issue... At least I think it is a max formula issue?

    Yeah I did and still it shows a 0.
  6. N

    Max Formula Issue... At least I think it is a max formula issue?

    Here is what I am trying to do. I have placed the values in column A into ranges like 0-1099, 1100-1499, 1500-1999, etc. So the question is how do I find the max price of the range 3000-3500. The answer should be 249900. A B 1 SQFT Price 2 3242 242000 3 2100 146500 4 2664 465900 5 3395...
Back
Top