If or conditional formatting?

  • Thread starter Thread starter Twiggy
  • Start date Start date
T

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?
 
Try the below formula...

=CHOOSE(SUMPRODUCT(--(ISNUMBER(A1:B1)))+1,"1o outstanding",
"1p payable","1p paid")
 
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
 
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")
 
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?
 
Back
Top