Good Morning,
I have got a multiple IF statement that i need to complete the original formula was against three columns but i need a fourth column now to be added, but i can't seem to add in the extra column into the the formula, heres an attached sample to help
many thanks
reg
Try this,
=IF(B2>TODAY()+1,"",IF(AND(C2="",D2=""),"",IF(AND(C2="",D2<>""),"TBA",C2)))
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thanks Old Chippy,
works like a charm
thanks reg
Glad to hear it - thanks for the feedback
You could also try
=IF(B2>TODAY()+1,"",IF(C2="",IF(D2="","","TBA"),C2))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks