If statment

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: If statment

  1. #1
    Board Regular
    Join Date
    May 2002
    Posts
    251
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    right now I have this formula in column D.

    =IF(ISERR(AA5/AA5)=TRUE,"",AA5-10)

    it just take the date value from column AA and subtract 10 days from column AA date, and puts the value in coulmn D.

    Now what I want to do is, I want to look in the column B, if column B has "Assembly" value in the cell, then It should subtract only 5 days instead of 10 days, rest it sould subtract 10 days.
    Any idea how I am going to play with this formula?
    Thanks in advance.
    Amna

  2. #2
    New Member
    Join Date
    May 2002
    Location
    Melbourne, Australia
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I would have a play around with a nested IF formula as below:
    =IF(ISERR(AA5/AA5)=TRUE,"",IF(B5="Assembly",AA5-5,AA5-10))

  3. #3
    New Member
    Join Date
    Oct 2002
    Location
    david sasson
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi this is David, try this:

    =IF(ISERR(AA5/AA5)=TRUE;"";IF(B5>0;AA5-5;IF(B5=0;AA5-10;0)))
    This is an arrey so don't forget to press Ctrl Shift Enter.
    What it does is it checks to see if there is any value in cell B5 if it does the it -5 if there is nothing in cell B5 then it -10.
    Hope this is what you need

    later
    david

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Perhaps
    =IF(LEN(AA5),(AA5-5)-(B5<>"Assembly")*5,"")

    would work for you.

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Just noticed this is a duplicate of
    http://216.92.17.166/board/viewtopic...7335&forum=2&3


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com