• 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. S

    give name to range of number

    Hi Master Narayan, thanks for your help..problem solved Hi Master Hui, that's right..Minggu1 has 8 days Your formula is great, solved the problem also. Hi Master Somendra, Change "week" to "minggu"....thinking out of the box..what a nice idea.. Thanks all my Masters.....thank you so much...
  2. S

    give name to range of number

    hi master...this is the data
  3. S

    give name to range of number

    hi guys, i'm bit confuse about how to give the name of list of number...before this, i used lookup to give the name, but when the range of data getting larger, i'm stuck.. here's the example: 1,2,3,4,5,6,7,8,9....999999 for each 10 numbers, i'll give their names = SPICY1, SPICY2, SPICY3...
  4. S

    if combine min formula prob!!

    Thanks....solved wif your calculation..
  5. S

    if combine min formula prob!!

    thanks 4 ur quick reply master......there is no conditions for that(no lookup)...it is calculation..if 75 = 1, so 76 = 1.0x or 95=4.8x..i got problem when i want to combine calculation and formula..this is what is think about =IF(MIN(G10*5,5)<0,0,xxxxxformulaxxxxx).. G10 is in...
  6. S

    if combine min formula prob!!

    hi, i want to ask sumthing that quite difficult to me...there a marking point min 0,max 5 based on the result given,the result is between 0 to 100.below 75 considered 0...therefor, >=75 until 100 will get 0 to 5...there is my coding =IF(MIN(G10*5,5)<0,0,MIN(G10*5,5)) but if the G10 is 75...
Back
Top