Windows 7 - Blank until data is entered

Asked By ksalv002 on 10-Aug-12 10:26 AM
I am 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 do not think I am inputting it correctly.
Please assist.

=IF(AND($Q5<=$P5,$Q5>=$R5),"Neutral",IF($Q5>$O5,"High",IF($Q5<$S5,"Low","")))




--
ksalv002




Claus Busch replied to ksalv002 on 10-Aug-12 03:54 PM
Hi,

Am Fri, 10 Aug 2012 14:26:41 +0000 schrieb ksalv002:


try:
=IF(COUNT($O5:$S5)<5,"",IF(AND($Q5<=$P5,$Q5>=$R5),"Neutral",IF($Q5>$O5,"High",IF($Q5<$S5,"Low",""))))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2