Blank until data is entered
I'm currently using this conditional function, which works fine, but I want it to only work when data is entered into all referenced cells. I 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,"H igh",IF($Q5<$S5,"Low","")))
Last edited by ksalv002 : August 10th 12 at 03:28 PM
|