problem with a formula

  • Thread starter Thread starter Mark W.
  • Start date Start date
M

Mark W.

I need some help with a formula.
It seem to be quite simple but I got so confused already that I gave
up and need some help. Let me explain:

I have 2 columns, say A, B.
I enter the date that something is due on in A
In column B I enter the date that I receive it
If B is equal or less then A it's OK but if B is blank
and today is passed A, then I need to put some formula
somewhere to flag it out "OVERDUE".
Keep in mind that not all rows in A contain dates, yet. I enter them
progressively as I receive documentation on the item.
So if a week ago I entered in A1 that something is due on 1/5/04
and today is 1/6/04 and B1 is still blank I want to flag it out.
Then today I enter in A2 due date 1/10/04 and I receive the item
and close it in B2 with date 1/8/04 then no flagging is necessary and
that flag cell remains blank.
I hope what I just described is clear for you guys to help me out
with. Please.
I think it requires multiple formula that I was always confused with
and never do it right, always miss something and get errors.
Appreciate any help

Mark
 
Hi Mark

I think your problem can be solved with a nested "IF formula".
Regarding your example you can enter in column C the following formula:
=IF((A1)="";"";IF(AND(A1<NOW()-1;B1="");"Overdue";IF(B1>A1;"Late
delivery";"OK")))

hope this helps
Frank
 
Hi Mark

I think your problem can be solved with a nested "IF formula".
Regarding your example you can enter in column C the following formula:
=IF((A1)="";"";IF(AND(A1<NOW()-1;B1="");"Overdue";IF(B1>A1;"Late
delivery";"OK")))

hope this helps
Frank
Click to expand...

Hi Frank
Thanks a lot, works perfectly
I analyzed it and seems to be pretty understandable
I just have problems with nested formulas
Thanks again
Mark
 
Mark said:
Hi Frank
Thanks a lot, works perfectly
I analyzed it and seems to be pretty understandable
I just have problems with nested formulas
Thanks again
Mark
Click to expand...

As I began learning the functions with nesting, I would use severa
columns and build each step of the process in one cell, the
consolidate into one cell. Makes a good way to learn and understand
 
Back
Top