Results 1 to 3 of 3

Multiple if functions or vlookup

Threaded View

jmjulie25 Multiple if functions or... 10-13-2012, 08:08 AM
Ace_XL Re: Multiple if functions or... 10-13-2012, 08:40 AM
jmjulie25 Re: Multiple if functions or... 10-13-2012, 08:58 AM
  1. 10-13-2012, 08:08 AM #1
    jmjulie25 is offline
    Registered User
    Join Date
    10-13-2012
    Location
    Manila Philippines
    MS-Off Ver
    Excel 2007
    Posts
    2

    Multiple if functions or vlookup

    Hi, I'm trying to make an online amortization calculator for my website.

    sample calculator.xlsx

    I'm trying to insert value (factor rates) to B27 from specific list depending on the value of Years to pay B10.

    I'm trying to use if functions, like I did in B15 but I just couldn't make it work. Also there a problem with B15 since I can't make it percentage instead of decimal.

    I would very much appreciate if you could help me. Thank you
    Last edited by jmjulie25; 10-13-2012 at 09:08 AM.
    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)

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1