If or conditional formatting?

[Twiggy]

Hi Folks

Can some one please help me on a formula? I've been messing with it but
can't quite get there.

I have two coloumns with dates or blanks and I need a formula to bring back
the status of the data

A B Status
date Blank 1p payable
date date 1p paid
Blank Blank 1o outstanding

I have tried an if statement but can't get it to bring back the status of
the blank cells, can anyone help please?

 

[Jacob Skaria]

Try the below formula...

=CHOOSE(SUMPRODUCT(--(ISNUMBER(A1:B1)))+1,"1o outstanding",
"1p payable","1p paid")

 

[Twiggy]

Thanks Jacob

Not quite working though, it's bring back 1o outstanding to all the cells,
any other ideas? I really appreciate your help

Thanks

 

[Jacob Skaria]

Do you have the dates in excel date format?

or else try the below version and copy down

=CHOOSE(COUNTA(A1:B1)+1,"1o outstanding","1p payable","1p paid")

 

[Twiggy]

Yey worked that time!

Jacob, you are a legend, thank you so much!!!!!!

 

[Twiggy]

HI

More help required URGENTLY!!!!!!

Jacob's formula worked, but now I need it to show another argument, I have
tried to fix it but I'm stuck!

A B Status

Date Blank 1P Payable
Date Date 1P Paid
Blank Blank 1o outstanding
Blank Date 1Q Query

Can anyone help please?