need help in creating a formula

**qazinomi** · 04-02-2013, 04:47 PM

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 previous date and A7 is empty then A8 show "argent" in red color. if A7 have number then it shows "paid"
if date is today and the A7 is empty then A8 show "Due Today". if A7 have a number then "paid"
if the date is in future then then it shows "due Later"

Thank you

**BarryTSL** · 04-02-2013, 05:26 PM

Try

Please Login or Register  to view this content.

**etaf** · 04-02-2013, 05:29 PM

try
=IF(A7<>0,"Paid",IF(A6=TODAY(),"Due Today",IF(A6>TODAY(),"due later", "argent")))

and use a conditional format for the word "argent"
=a8="argent"

see attached

**arlu1201** · 04-03-2013, 01:24 AM

qazinomi,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.