K
ksalv002
I'm currently using this conditional function, which works fine, but
want it to only work when data is entered into all referenced cells.
tried to insert COUNTIF, but don't think I'm inputting it correctly
Please assist.
=IF(AND($Q5<=$P5,$Q5>=$R5),"Neutral",IF($Q5>$O5,"High",IF($Q5<$S5,"Low",""))
want it to only work when data is entered into all referenced cells.
tried to insert COUNTIF, but don't think I'm inputting it correctly
Please assist.
=IF(AND($Q5<=$P5,$Q5>=$R5),"Neutral",IF($Q5>$O5,"High",IF($Q5<$S5,"Low",""))