Results 1 to 4 of 4

Thread: Excel

  1. #1
    New Lounger
    Join Date
    Aug 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm a newbie with Excel and am not familiar with the jargon or syntax!
    Can do the simple + - * etc. But I'm having trouble understanding the 'help' info.
    This is an example of what I'm trying to do.............
    Cell under A contains .... 2 Cell under B .... 10 Cell under C .... 0.25 Cell under D... 0.2
    Cell under E .... Will be left blank, and into which at a later time, will have a text entry, being
    either W or L or P4 or P5 or W/P4 or W/P5
    Cell F will be the result of one of five equations, depending on the entery under E
    Cell G will be the result of an equation only if L was entered under E
    Examples : F1 will equal (providing E1 has the text W/P4 entered) the sum of (2*10) and
    (2*10*0.25)
    G1 will contain the result of 2*10 only if an L was entered in E1
    All my attempts are greeted with 'not valid'!!! Help, please.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Welcome to the Lounge!

    The formula in G1 could look like this:

    =IF(E1="L",A1*B1,"")

    If E1 equals "L", the formula returns the value of A1*B1, otherwise it returns an empty string.

    The formula in F1 will be much more complicated. It'd be something like

    =IF(E1="W",11,IF(E1="L",22,IF(E1="P4",33,IF(E1="P5 ",44,IF(E1="W/P4",A1*B1+A1*B1*C1,IF(E1="W/P5",66,""))))))

    where 11, 22, 33, 44 and 66 will have to be replaced with the expressions you want there.

    I have attached a sample workbook with these formulas.
    Attached Files Attached Files

  3. #3
    New Lounger
    Join Date
    Aug 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='787409' date='03-Aug-2009 17:17']Welcome to the Lounge!

    The formula in G1 could look like this:

    =IF(E1="L",A1*B1,"")

    If E1 equals "L", the formula returns the value of A1*B1, otherwise it returns an empty string.

    The formula in F1 will be much more complicated. It'd be something like

    =IF(E1="W",11,IF(E1="L",22,IF(E1="P4",33,IF(E1="P5 ",44,IF(E1="W/P4",A1*B1+A1*B1*C1,IF(E1="W/P5",66,""))))))

    where 11, 22, 33, 44 and 66 will have to be replaced with the expressions you want there.

    I have attached a sample workbook with these formulas.[/quote]

  4. #4
    New Lounger
    Join Date
    Aug 2009
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Many thanks Hans. I'll try it out when I have some time......maybe tomorrow.
    Regards
    Don

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •