View Single Post
  #1   Report Post  
ksalv002 ksalv002 is offline
Junior Member
 
Posts: 1
Default 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