need help in creating a formula

Q

qazinomi

hi
i need help in creating formula

lets suppose a cell A6 have a date in it. and cell A7 have some number

in cell A8 i want to insert a formula that tell me if A6 have previou
date and A7 is empty then A8 show "argent" in red color. if A7 hav
number then it shows "paid"
if date is today and the A7 is empty then A8 show "Due Today". if A
have a number then "paid"
if the date is in future then then it shows "due Later"

Thank yo
 
D

Dave Cromley

qazinomi,
I just put your words into a formula:
Put =TODAY() in A1
Put an earlier date in A3:A4
Put today's date in A5:A6
Put a later late in A7:A8
Put nothing in A3,A5,A7
Put a number in A4,A6,A8
In C3 put =IF(A3<$A$1,"<",IF(A3=$A$1,"=",">"))
and copy down to C8
In D3 put =IF(A3<$A$1,IF(B3="","argent","paid"),IF(A3=$A
$1,IF(B3="","Due Today","paid"),"Due later"))
and copy down to D8
Do the red with conditional formatting.
I hope this helps, Dave
 
Top