Formula question

Thanks:  0
Likes:  0

1. ## 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. ## 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. ## Re: Formula question

Originally Posted by SammyKoo
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

#### Posting Permissions

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