Results 1 to 17 of 17

Formula Error - Don't Know What the Error Is

Threaded View

  1. #1
    Registered User
    Join Date
    06-10-2020
    Location
    Toronto
    MS-Off Ver
    2007
    Posts
    13

    Formula Error - Don't Know What the Error Is

    Can someone please tell me what is wrong with this formula based on the information below it? I copied it exactly as was posted online and got an error message (with no explanation as to what the error is). This formula is supposed to figure out one of the "Greek" values for calculating call/put option prices and the answer to this particular formula is supposed to be 0.59730.

    =(LN((B3\EXP(-B8\B7))/B4)+((B6+((B5)^2)/2)\B7))/((B5)\SQRT(B7))

    B2 -30-Jun-18
    B3 - 550
    B4 - 500
    B5 - 25%
    B6 - 1%
    B7 - 0.504
    B8 - 2%
    B9 - 1200
    B10 -31-Dec-18
    B11 - 11


    Thanks in advance
    Last edited by Options78; 06-10-2020 at 06:16 PM. Reason: More Specific Title

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 03-24-2020, 07:27 AM
  2. Replies: 3
    Last Post: 01-10-2019, 09:34 AM
  3. Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  4. Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  5. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  6. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  7. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1