Results 1 to 9 of 9

Multiple IF OR functions (Nested)

Threaded View

cady923 Multiple IF OR functions... 05-28-2009, 01:22 PM
modytrane Re: Multiple IF OR functions... 05-28-2009, 01:39 PM
cady923 Re: Multiple IF OR functions... 05-28-2009, 02:11 PM
modytrane Re: Multiple IF OR functions... 05-28-2009, 02:22 PM
modytrane Re: Multiple IF OR functions... 05-28-2009, 02:25 PM
  1. #1
    Registered User
    Join Date
    11-21-2008
    Location
    new hampshire
    Posts
    16

    Multiple IF OR functions (Nested)

    Hi All,

    In the attached file i am trying to convert USD to different currencies based on Pricing Category. For Example, if the pricing Category is Parts i want to convert to GBP. to do this i need to multiple USD*.524*1.28. If the pricing category is System, i want to convert to GBP and need to multiply USD*.694*1.85. I would assume i need an IF OR function, however, my experience with functions is somewhat limited. I had started the formula using =IF(OR(C2="PARTS",C2="PART KITS"),I2*0.524*1.28),IF(OR(C2="SYSTEMS",C2="SYSTEM KIT"),I2*0.694*1.85)

    Any help is appeciated!
    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