Results 1 to 2 of 2

Formula for Excel

Threaded View

  1. #1
    Registered User
    Join Date
    01-05-2009
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    1

    Formula for Excel

    I work for a Financial Advisor company & am setting up a excel spreadsheet to automatically calculate monthly payments for mortgages.

    One question:

    In an already formulaed cell - can i have two alternative calculations with someway to switching from whatever calculation is required

    e.g.

    in cell B6 i have the loan to value formula which calculates the mortgage amount (B5) against the valuation of the property (B4) i.e. =SUM(B5/B4)

    what i want it to alternatively show is the max loan available for a particular product i.e. =SUM(B6*B4)

    can this be done

    kind regards
    Last edited by scottbloom1; 01-05-2009 at 01:53 PM. Reason: Help for double formulas in a single cell

Thread Information

Users Browsing this Thread

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

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