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

Some videos you may like

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
  •