Results 1 to 5 of 5

using the plus sign in a formula

Threaded View

  1. 11-11-2015, 04:19 PM #1
    Caher
    Caher is offline
    Registered User
    Join Date
    11-11-2015
    Location
    UK
    MS-Off Ver
    2010
    Posts
    2

    Thumbs up using the plus sign in a formula

    Hello all,

    i was wondering what the difference is when using a plus sign in a compound interest formula ie:

    =K9*(1+K10/K11)^(K11*K12)

    =K9*(1.04/K11)^(K11*K12)

    the substitute is an interest rate of 4% - not sure why the first works and the lower one does not?
    thanks
    Last edited by Caher; 11-11-2015 at 05:05 PM. Reason: solved
    Reply With QuoteRegister To Reply
« 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. Trying to create Sign in Sign out sheet with time stamp
    By InNeedOfHelp88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2015, 07:11 PM
  2. [SOLVED] Employee sign-in userform - Multiple sign ins?
    By Battletoads in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2014, 10:57 AM
  3. How to take out the numbers which is after sign (^) and before sign (/) in text
    By js1537 in forum Excel General
    Replies: 3
    Last Post: 03-13-2013, 01:20 AM
  4. Decimal Sign Replaced with ; Sign
    By lopiner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2009, 08:47 AM
  5. XL invoice replace the dollar sign with euro sign
    By Pamela casares in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-16-2005, 04:25 PM
  6. [SOLVED] Need to use the + sign but not in a formula
    By Denise in forum Excel General
    Replies: 2
    Last Post: 07-26-2005, 11:05 AM

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