Results 1 to 3 of 3

Thread: Podcast Epsiode 1175 BUG
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jan 2010
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Red face Podcast Epsiode 1175 BUG

    In Episode 1175 When Bill adjusts the formula the value reads as 7.
    However when he copys it down the value changes to 8.
    I had a closer look and when he copies the formula down ALL the data values (B2:M4) change. Why is this? What happened there?

  2. #2
    Board Regular
    Join Date
    Dec 2005
    Location
    Basingstoke (UK)
    Posts
    2,390
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Podcast Epsiode 1175 BUG

    Hello and welcome to The Board.

    My guess is that Bill has used the RAND() function to get some example data very quickly - this is the sort of thing that I do.
    I would select a range of cells, enter something like
    =RAND()/10
    and then enter the formula using
    Ctrl+Enter
    to enter the formula in all selected cells. Those cells would then be formatted as percentage.
    The RAND() formula will recalculate every time the worksheet is recalculated (for example when another formula is copied-down).
    Never give way to anger - otherwise in one day you could burn up the wood that you collected in many bitter weeks.

  3. #3
    . MrExcel's Avatar
    Join Date
    Feb 2002
    Location
    Merritt Island Florida
    Posts
    870
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Podcast Epsiode 1175 BUG

    Derek - exactly right...

    I probably used =RANDBETWEEN(30,60)/1000 to generate that range of percentages between 3 & 5.9%.

    Usually, I would have converted those formulas to values using Paste Values, but it looks like I forgot this time.

    Good catch!

    Bill
    View a collection of recent Excel articles in the Excel Daily News

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •