If formula with 3 conditions?

[LMills77]

Hi people,

I think I'm having a brain freeze at the moment. This is bound to be really simple - I'm generating an aged debtors report and I need a formula to return one of three answers:

Overdue
Today Today
Not Due

If the number of days overdue is greater than 0, I need it to return '"Overdue." if the value is 0, to return "Due Today." If the value is minus, "Not Due."

Can anybody provide me with a quick formula to show this please?

Thanking you!

Lee.

[AliGW]

Try this:

=IF(A1>0,"Overdue",IF(A1<0,"Not Due","Due Today"))

[LMills77]

And there we go - so simple.

Thanks for the prompt reply - much appreciated.

Lee.

[AliGW]

No worries.

[MarvinP]

Hi Lee,
If you want to use the Sign() function then this formula will also work for you. I don't know why Ali thinks you date is in A1.

Please Login or Register  to view this content.

See the attached file below for more than one date:
Book Due using Sign and Choose.xlsx

[AliGW]

Lee didn't say where it was, Marvin - why do you think it's in A2? If the specific cell isn't named, I always use A1 in sample formulae. Happy to learn if you think I've been getting it wrong all these years.

[MarvinP]

@Ali,
I just feel a workbook showing the problem and an answer is more informative than a formula that is unattached. Just like the yellow heading suggests. We all have our ideas on what is enough information for the OP to get an answer. I just didn't see how A1 was a part of the OP's problem without seeing a workbook on where the data lived. As both of us being in the teaching profession, I guess it is our own call on what is enough since there is no rule on that and we all work for free?

[AliGW]

Sorry, Marvin - I’m not understanding why my use of A1 as the cell containing the number of days is any different to your use of A2 in yours. You can’t give a suggested formula, which is what the OP asked for, without making cell references. If they haven’t provided a workbook, then it’s up to them to adapt it for their own set-up. I really didn’t feel the need to provide a demo worksheet myself for such a simple formula. If I were suggesting something more complex, such as a Power Query solution, then I would. Anyway, Lee is happy and does not appear to have misunderstood the formula I suggested, in fact he commented himself on its simplicity. I’m obviously missing something here.