| 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 |
| 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 | |||
Threaded Mode
