Hey guys,
So I am getting annoyed at myself. I have a date in cell D9 and if that cell is before today's date I want it to say "over due", if it's not I want it to stay blank. But I only want it to do this if cell F9 is blank.
This is what I have and its annoying me that I can't get it to work.
=IF(D9<TODAY(),"Over due","")
I can not figure what to put in front of it to get it to only do this IF cell F9 is blank.
It should be so simple which is why it's annoying me.
Try this..
Formula:
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
=IF(AND(D9<TODAY(),F9=""),"Over due","") ??
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi,
One way
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Perfect!!
Thank you all for your help on this! Greatly appreciated
Sorry but I also need it to ignore this rule is cell C10 is empty. I did try myself but it wouldn't play?
Thanks
May be this...
Formula:Please Login or Register to view this content.
Many thanks again :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks