Results 1 to 8 of 8

IF AND Formula HELP

Threaded View

  1. #1
    Registered User
    Join Date
    01-14-2019
    Location
    Scotland
    MS-Off Ver
    Office365
    Posts
    3

    IF AND Formula HELP

    Hi All!

    I am trying to create something totally out with my capabilities so hope you can help...…

    I have created a table from which I have created a list, when I choose these items from a list I want them to add different data to different cells...

    For Example...

    =IF(A6="PL202 Type W","0.5","0") but I want "0.5" to be multiplied by B6 which is a number AND only IF B6 >0 (this is the easy part hopefully)

    I also want

    =IF(A6="PL202 Type W","14","0") but I also want different permutations too such as =IF(A6="PL202 Type X","6","0") but I want them to all add together in one cell as there may be 20 different options from 20 different cells.

    Really hope you can help.

    Thanks in advance
    Attached Files Attached Files
    Last edited by kevjkeenan; 01-14-2019 at 11:41 AM. Reason: Title Change

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] complicated if
    By cotix in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-26-2014, 05:35 AM
  2. [SOLVED] Complicated Look UP
    By Excel Dumbo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-11-2013, 08:46 PM
  3. Help with complicated look up
    By GAVGAV27 in forum Excel General
    Replies: 8
    Last Post: 05-05-2012, 05:30 PM
  4. Complicated If/Then
    By Fcroft in forum Excel General
    Replies: 4
    Last Post: 08-13-2010, 03:06 PM
  5. complicated SUM
    By dz6kb4 in forum Excel General
    Replies: 3
    Last Post: 12-07-2008, 10:38 AM
  6. Need help w/ complicated fx
    By rgood in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-23-2008, 02:43 AM
  7. This is more complicated than it looks.
    By dollarbill79 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-13-2006, 06:35 PM
  8. Something perhaps a little complicated
    By brodiemac in forum Excel General
    Replies: 1
    Last Post: 06-13-2006, 10:15 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1