| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Am I to assume...
Am I to assume that there is not a way to use a range in an IF statement. If
not is there a way to incorporate #N/A error into a conditional format? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Am I to assume...
Depends on what you are trying to do. For example, we might be interested in
knowing if any cells in A1 thru A1000 have #N/A: =IF(ERROR.TYPE(SUM(A1:A1000))=7,"error present","clean") This also shows a way to test for #N/A -- Gary''s Student - gsnu200777 "Cerberus" wrote: Am I to assume that there is not a way to use a range in an IF statement. If not is there a way to incorporate #N/A error into a conditional format? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Am I to assume...
Thank you for your help.
"Gary''s Student" wrote: Depends on what you are trying to do. For example, we might be interested in knowing if any cells in A1 thru A1000 have #N/A: =IF(ERROR.TYPE(SUM(A1:A1000))=7,"error present","clean") This also shows a way to test for #N/A -- Gary''s Student - gsnu200777 "Cerberus" wrote: Am I to assume that there is not a way to use a range in an IF statement. If not is there a way to incorporate #N/A error into a conditional format? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What would Excel Assume if DATE left blank | Excel Worksheet Functions | |||
| Can I assume everyone has Scripting Run Time (scrrun.dll) on C:\WI | Excel Discussion (Misc queries) | |||
| Number of days between 2 dates, if end date is blank assume todays | New Users to Excel | |||
| assume the number I type is in the thousands | Excel Discussion (Misc queries) | |||
| Can I assume the program has crashed? | Excel Discussion (Misc queries) | |||
Linear Mode
