Formula question

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

Thread: Formula question

  1. #1
    New Member
    Join Date
    Aug 2017
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formula question

     
    HI all,

    I could use some help. I really tried to figure this out on my own but can't quite get there.

    I have two columns I am trying to compare but they have different data.

    I2 J2 K2
    Days submittal date
    84 Formu 7/14/16



    what I am working to do is shows an if statement. If column I2 is greater than 7 then it will show "late submittal", otherwise it will show "pending submittal"
    =IF(I2>7,"LATE SUBMITTAL","PENDING SUBMITTAL")

    here is where I need to add something in for Column K2.
    if K2 is showing a date that is I want JT2 to be blank. is that possible?

    Days from Design Late/Pending 1ST PERMIT SUBMITTED
    84 LATE SUBMITTAL 7/14/2016

  2. #2
    New Member
    Join Date
    Nov 2017
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula question

    what other data will there be in your K2 other than dates?
    and what if it is not showing a date, what would it shows?
    i would suggest to use the if function thou, =if(K2<1,"something","")
    not sure if this helps

  3. #3
    New Member
    Join Date
    Aug 2017
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula question

      
    Quote Originally Posted by SammyKoo View Post
    what other data will there be in your K2 other than dates?
    and what if it is not showing a date, what would it shows?
    i would suggest to use the if function thou, =if(K2<1,"something","")
    not sure if this helps

    TRYING TO DO SOMETHING LIKE THIS

    =IF(I2="",IF(M2>J2+7,"LATE SUBMITTAL","ON TIME SUBMITTAL"), (M2>I2+7,”LATE SUBMITTAL”,”ON TIME SUBMITTAL”))

    BUT I GET AN ERROR.

    Coax Design Complete Fiber Design Complete Days from Design 1ST PERMIT SUBMITTED LATE/ON TIME
    08/30/2017 no data 84 7/14/2016 ON TIME SUBMITTAL

User Tag List

Tags for this Thread

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