Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Indirect question

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Qld, Australia
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi everyone,

    I hope someone can help me with this little query.

    I have a number calculated in A3 that I have rounded to 0 decimal places. I want to refer to this number in cell A1 and adding text after it.

    As an example in A1 =indirect(A3&"text")

    How can I make the number from A3 rounded in A1? When I try the above it calls a number of a large number of decimal places.

    Thanks for your help.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =indirect(rounddown(A3)&"text") ?

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Qld, Australia
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Nope, no luck, thanks anyway.

    I played around a little and entered the following but still no success:

    =INDIRECT((ROUND(A3,0))&"text")

    giving a #ref! error.

    Mmm frustrating..

  4. #4
    New Member
    Join Date
    Feb 2002
    Location
    Qld, Australia
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ahh got it. Thanks anyway all.

    Ended up placing the round formula in another cell and then referring to this new cell in cell A1.


  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    try this,
    a1=a3, in a2 enter the following:
    =if(a1>0,"your text","")

    there ya go!

    now someone fix my gannt problem

    cheers

Some videos you may like

User Tag List

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
  •