+ Reply to Thread
Results 1 to 5 of 5

How do I reverse a log function

  1. 11-20-2018, 03:03 PM #1
    born2dive00
    born2dive00 is offline
    Forum Contributor
    Join Date
    01-29-2018
    Location
    United states
    MS-Off Ver
    2019
    Posts
    242

    How do I reverse a log function

    How do I reverse this=-LOG(0.197484177)?
    When I put in =-LOG(0.197484177) I get 0.704467696

    I need to go from 0.704467696 to 0.197484177 by reversing the log

    Please help
    Thanks
    Brad
    Last edited by born2dive00; 11-20-2018 at 03:21 PM.
    Reply With QuoteRegister To Reply
  2. 11-20-2018, 03:24 PM #2
    José Augusto
    José Augusto is offline
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: How do I reverse a log function

    Try in A1

    =-LOG(0.197484177)

    In B! try

    =10^(-A1)
    Reply With QuoteRegister To Reply
  3. 11-20-2018, 03:25 PM #3
    canapone
    canapone is offline
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: How do I reverse a log function

    Hi All,


    =10^-0.704467696

    should reverse the Log

    Regards

    edit: sorry Josè Augusto: I did not mean to override...
    Last edited by canapone; 11-20-2018 at 03:32 PM.
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.
    Reply With QuoteRegister To Reply
  4. 11-20-2018, 03:31 PM #4
    born2dive00
    born2dive00 is offline
    Forum Contributor
    Join Date
    01-29-2018
    Location
    United states
    MS-Off Ver
    2019
    Posts
    242

    Re: How do I reverse a log function

    Solved Thank you guys
    Reply With QuoteRegister To Reply
  5. 11-20-2018, 03:37 PM #5
    José Augusto
    José Augusto is offline
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: How do I reverse a log function

    Quote Originally Posted by canapone View Post
    ...

    edit: sorry Josè Augusto: I did not mean to override...
    No problem.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. IRR in 'reverse'
    By Catflappo in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-15-2021, 12:35 AM
  2. [SOLVED] Reverse strings udf function to reverse numbers
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2015, 07:03 AM
  3. Reverse Sum
    By zippyzip in forum Excel General
    Replies: 0
    Last Post: 06-16-2011, 03:42 PM
  4. Reverse Data In A Cell / Reverse Cell Contents
    By nostawydoc in forum Excel General
    Replies: 5
    Last Post: 12-18-2009, 05:20 PM
  5. Reverse Sum
    By philcava in forum Excel General
    Replies: 2
    Last Post: 07-13-2007, 08:09 AM
  6. Reverse Sum
    By vjeevar in forum Excel General
    Replies: 2
    Last Post: 02-08-2006, 06:10 PM
  7. Tax and Reverse Tax
    By Atreides in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2006, 11:00 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1