Formula below works perfectly fine but I need to add another IF function and not sure how to do that.
In Column S, I have "yes" or "no" in each cells and I need the new formula to say that IF there's a "yes" in S5, then take the formula below. If there's a "no", T5 should be blank.
Any help would be greatly appreciated.
=(IF(T$3<'Input Sheet'!$F53,'Input Sheet'!$E53/13,(IF(T$2>'Input Sheet'!$I53,'Input Sheet'!$K53/13,(IF((AND(T$2>'Input Sheet'!$F53,T$3<'Input Sheet'!$I53)),'Input Sheet'!$H53/13,(IF(AND(T$2<='Input Sheet'!$F53,T$3>='Input Sheet'!$F53),(((TEXT('Input Sheet'!$F53-Period!T$2,$A$1)+1)/28*'Input Sheet'!$E53/13)+(TEXT(T$3-'Input Sheet'!$F53,$A$1)/28*'Input Sheet'!$H53/13)),IF(AND(T$2<='Input Sheet'!$I53,T$3>='Input Sheet'!$I53),(((TEXT('Input Sheet'!$I53-Period!T$2,$A$1)+1)/28*'Input Sheet'!$H53/13)+(TEXT(T$3-'Input Sheet'!$I53,$A$1)/28*'Input Sheet'!$K53/13)),"problem")))))))))
Bookmarks