Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLANK CE | Excel Worksheet Functions | |||
Using a Macro in Excel 2004 to move entered data from one sheet toanother and space between rows when next data is entered? | Excel Programming | |||
Making a cell show blank until data is entered | Excel Discussion (Misc queries) | |||
Data not entered yet - formula calculate blank | Excel Discussion (Misc queries) | |||
Formulas returning a blank if no data entered in one cell | New Users to Excel |