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",""))) |
Blank until data is entered
Hi,
Am Fri, 10 Aug 2012 14:26:41 +0000 schrieb ksalv002: 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. =IF(AND($Q5<=$P5,$Q5=$R5),"Neutral",IF($Q5$O5,"H igh",IF($Q5<$S5,"Low",""))) 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 |
All times are GMT +1. The time now is 03:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com