Forum Discussion
Excel Formula help
Hey Guys Hope all are well. I need to formula and I'm having trouble. So if A is a date. If B,C,D say yes I want to add 2 weeks on from A into E. If that makes. thanks in advance.
A basic solution might be
= IF((ColumnB = "Yes") * (ColumnC = "Yes") * (ColumnD = "Yes"), ColumnA + 14, "")
PeterBartholomew1 Hi Pete.
Looking at this little closer. I only need 1 Column to say yes. so what would that formula be? I've attempted to amend but I'm getting a spill error
Change the formula to
= IF((ColumnB = "Yes") + (ColumnC = "Yes") + (ColumnD = "Yes"), ColumnA + 14, "")Replace ColumnA, ColumnB etc. with the ranges that you use.
Alternatively, enter the following formula in for example E2, then fill down:
= IF(OR(B2:D2 = "Yes"), A2 + 14, "")
