The result is that the entire formula - including the equal sign - is surrounded by curly braces.
Getting #VALUE!
for an Answer
If cells B6 and B7 display the #VALUE!
Find the Largest Negative or Positive Number in Excel
Use the MAX - IF array formula in Excel to find the largest positive or negative value for a range of data. A step by step example is included.
