|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 10th 12, 03:26 PM
|
|||
|
|||
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. 
|
| Ads |
|
#2
August 10th 12, 08:54 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLANK CE | Morton Detwyler[_2_] | Excel Worksheet Functions | 9 | July 20th 08 05:56 PM |
| Using a Macro in Excel 2004 to move entered data from one sheet toanother and space between rows when next data is entered? | [email protected] | Excel Programming | 1 | June 4th 08 05:08 PM |
| Making a cell show blank until data is entered | bc292 | Excel Discussion (Misc queries) | 2 | April 1st 07 06:08 PM |
| Data not entered yet - formula calculate blank | DRondeau | Excel Discussion (Misc queries) | 1 | September 12th 06 05:56 PM |
| Formulas returning a blank if no data entered in one cell | Mifty Jackson | New Users to Excel | 3 | March 31st 05 04:37 PM |
Linear Mode
