I have a complex formula going and for some reason the only way it returns the correct answer on the last portion of the formula is if the greater/less than sign is flipped around? I enlarged the specific sign that I have currently have flipped around so the formula works, but the way it should read is that if the vlookup is greater than, not less than. Can anyone help with this? Thanks!
=IF(F28=1,IF(VLOOKUP(G28,$AB$2:$AC$15,2,FALSE)>=T28,T28,T28+U28),IF(VLOOKUP(F28,$Z$2:$AA$26,2,FALSE)<=T28,T28,T28+U28))
=IF(F28=1,IF(VLOOKUP(G28,$AB$2:$AC$15,2,FALSE)>=T28,T28,T28+U28),IF(VLOOKUP(F28,$Z$2:$AA$26,2,FALSE)<=T28,T28,T28+U28))