| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#REF! Error Resolve?
Thanks much! That did it!
"Dan the Man" wrote: The formula below will produce the #REF! Error in cell L4 until data is input in cells A4 and B4. Once data is input, the #REF! error will go away, and be replaced with a numerical outcome of 0 or 1. Is there an addition to the formula below which I can use to just leave the cell "blank" until the data is input in A4 and B4. I just hate seeing that #REF! Error! =IF(AND(SUMPRODUCT(--(rnga<""),--(rngb<""),--(rnga=$A4),--(rngb=$B4))1,C4<"x"),1,0) Thanks, Dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Did you ever resolve this? | Excel Discussion (Misc queries) | |||
| Please-please-HELP!!! Need to resolve this - Allocation Formula | New Users to Excel | |||
| How do I resolve debug error macro Excel 2000? At least, any lead | Excel Discussion (Misc queries) | |||
| How do I resolve too many different formats in a spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I resolve error message 25090 | Setting up and Configuration of Excel | |||
![Dan the Man[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
