thank you i revised it with this:
=IF(BQ24=12,"yes",IF(BQ24=13,"no",""))
but the problem is the formula needs to know that also if BL27 =12 then return "NO" also is that possible to include? thanks so much again
ADVERTISEMENT
thank you so much formulas keep colliding causing issues no fault to you trying to re write it -- can we incorporate if U4 = "NO" then then U5 should also = "NO"? i know its tricky im sorry i appreciate all your help.
=IF(BL27=0,"no",IF(BQ24=12,"yes",IF(BQ24=13,"no","")))