Formula question

Jillybean9621

New Member
Joined
Aug 31, 2017
Messages
8
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
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,981
Members
448,538
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top