Results 1 to 5 of 5

How to nest more than 7 functions in Excel with If Function

Threaded View

  1. #1
    Registered User
    Join Date
    06-28-2011
    Location
    dubai
    MS-Off Ver
    Excel 2002
    Posts
    3

    How to nest more than 7 functions in Excel with If Function

    Hello,

    I need some help in nesting more than 7 functions in Excel with "If" function.

    I have uploaded the excel sheet for your perusal.

    I am trying to create a formula that when you choose the currency in Column E, the result

    in Column G would be the conversion to USD, using the different conversion rates in column W which is linked to MSN money and updated automatically

    Unfortunately, I have more than 7 Currencies and the If function is not accepting more.

    Can you help please.

    Many thanks
    Attached Files Attached Files

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