Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Lv 31,660 points

Prayera

Favorite Answers61%
Answers166

  • variable range in excel?

    hey, i'm not an excel expert, and i'm trying to adapt a formula here, but it doesn't change the way i want. can you tell me what i'doing wrong (or what i should change)? thank you

    in the first row i have =COUNTIF(M2:M2,1)

    second: =COUNTIF(M2:M3,1)

    third: =COUNTIF(M2:M4,1)

    i think you got the idea. i want only the last part of the range to change, with one cell at a time. but when i pull the auto fill corner, it changes both sides by one. and i cannot just write the formula manually for each row.

    i hope i was clear. so any ideas?

    3 AnswersSoftware9 years ago

  • f(n)=? (when it calculated how many times number 2 appears in numbers from 1 to n?

    f(n) calculates how many times number 2 appears in numbers from 1 to n. For example, f(2)=1, and f(12)=2. What is the first n for which f(n)=n.

    Please, i don't only need the answer (i assume i can slowly get to it as well), I also want to know how you get there, the logarithm, the way you think.

    Thank you for your help!

    2 AnswersMathematics9 years ago