Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Engineering Function - Imaginary number format (2003)

    One of our engineers has called and asked me how to format an "imaginary" number he created using the enginering function of IMDIV.

    In Cell K36 the number is 0.68+263i
    in cell K38 the number is 1.75+9i

    His formula is =IMID(K38,K36)

    The result is 2.26403588416245-8.00211402165516E-002i

    He wants to have 2 decimals with the imaginary number showing

    I can't say I even really understand his question, so if I'm not making sense, please let me know and I'll try to get more information.

    Thank you!!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Engineering Function - Imaginary number format (2003)

    IMID? I Assume you meant IMDIV.

    The following monster formula should do what the engineer wants:
    <code>
    =COMPLEX(TEXT(IMREAL(IMDIV(K38,K36)),"0.00"),TEXT( IMAGINARY(IMDIV(K38,K36)),"0.00"))
    </code>
    He should be able to adapt this if needed.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Engineering Function - Imaginary number format (2003)

    Yes, you're right. I mistyped it. Sorry. I was looking at a screen print with about a 2 pt font. Thanks for the formula. I'll pass it on to him tomorrow. Is there ANYTHING you can't answer? Wow. Thank you!

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts

    Re: Engineering Function - Imaginary number format (2003)

    I was hoping you hadn't mistyped it.
    I thought it might have been a custom function of his.
    Because with the numbers given for K36 and K38 the answer should be
    3.42375076779547E-002-6.5654695618973E-003i
    and not
    2.26403588416245-8.00211402165516E-002i
    as stated.

    I hope this engineer isn't working on anything critical like Viking Voyager landings.

    Hans - your solution was of course elegant
    ..I assume you meant "complex formula" rather than "monster formula"

    zeddy

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Engineering Function - Imaginary number format (2003)

    <img src=/S/blackteeth.gif border=0 alt=blackteeth width=20 height=20>

Posting Permissions

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