excelmathexcel-formulaformulaformula-editor
what is the wrong with this formula always get this error in the the pic attached
excl formula
=IF(OR(B2:D2>10;E2>20);TRUE;FALSE)
Solution
It looks like you haven't got Microsoft365 which means an array calculation within OR() needs to be CSE-confirmerd (Control+Shift+Enter). For Microsoft365 users this is done by default and your formula would actually work. You could now either use CSE-entering, or circumvent that using other methods to inspect a range of cells. For example using MAX():
=IF(OR(MAX(B2:D2)>10,E2>20),"Special Order","No")
- COUNTIFS across multiple columns with multiple criteria
- Download Google Drive File from Excel Sheet using VBA
- Excel VBA Insert Column when Value Changes and add formula
- How to use left on a range in VBA?
- Capping Consecutive delimiters during text file importing
- How to get only visible category labels of excel chart via vba code
- Output all cell colors from a range in Excel using Office Scripts
- Difference between Interop.Excel and Tools.Excel?
- Excel - Array Formula to skip empty cells
- How can I resolve error: object '_global' failed in MS Word Macro?
- Occurrence by month using Excel Functions
- Strange behavior in Excel when counting Work Hours and Work Super Hours
- Calling a userform and returning a value
- how to get excel chart's main title text using python openpyxl library
- type mismatch in for cycle
- Autofill only non-empty cells in a column (excel) and skip filled cells
- Code help for Excel VBA for-loop which checks if multiple ListBoxes have values?
- Analyze Excel and XML file using Azure Synapse
- Evaluate Spline (y = f(x)) in Excel
- Strange issue with str function versus Str
- How do I get a range's address including the worksheet name, but not the workbook name, in Excel VBA?
- Need help fixing my excel formula so it doesn't show #VALUE! error in end result
- How to zero fill a number inside of an Excel cell
- Refreshing Conditional Formatting in Sheet Every 20 Seconds
- Get length of array?
- PivotTable Refresh error in the same sheet
- Putting a concatenate inside of a count if
- Can I guarantee the Image Formula Function is finished before printing the result?
- Unable to connect via ODBC in Excel (while connection test works fine)
- How can i transfer Visible Filtered Data from a table into a multi dimensional array?