Need an If Function that will lookup if certain criteria not met

[missmea2005]

I have a code that I want to lookup a value in another sheet if the date is past due

Please Login or Register  to view this content.

I want the cell to yield current if N6 - O6 >20, but if it is N6-O6 <20 I want it to search 'Monthly Claims'!G6 for a value if there is a value I want it to yield "Entered" if there is not value I want it to yield "Not Entered Yet"

[jeffreybrown]

Maybe

Please Login or Register  to view this content.

[Richard Buttrey]

Hello,

I'm not clear whether with your IF statement you mean the SUM of N6:O6 > 20 or any value in N6:O6 >20.

Perhaps upload your workbook with some manually calculated results so that we can be sure.

[missmea2005]

Here's the attachement and I'm trying to get the forumula in the Atlanta Public Schools Tab

[missmea2005]

I want it to take the difference between the current date and the due date and if it's over twenty days I need it to search the monthly claims sheet to see if they have entered a claim and if not then I want it to say not entered yet

[jeffreybrown]

forumula in the Atlanta Public Schools Tab

I don't see a tab with this name?

take the difference between the current date and the due date

Where is the due date?

Where is this formula being entered, Monthly Claims H6 and down?

In your orginal formula you have made O6 and N6 absolute but was this your intention?

Sorry, but I am not seeing the big picture here...

[Richard Buttrey]

Sorry, misread the original. I thought N6-O6 was a range rather than a subtraction.

Presumably Jeff's answer now sorts it?

[missmea2005]

Thanks!!!! Jefferey!!!!!!!!! That did it!

[jeffreybrown]

Okay, I guess that works then...

You are most welcome, we are glad to help and thanks for the feedback