<div>
You may try this <b>Array Formula</b>...<br />
<br />

<pre><code id="code-20-42977710-1">=MAX(IF(ISNUMBER(A1:C1),A1:C1))</code></pre>
</div>


You may try this Array Formula...



=MAX(IF(ISNUMBER(A1:C1),A1:C1))

<div>
Cannot without array or VBA?
</div>


<div>
Can you use IFERROR on the entries in A1:C1 to return zero?<br />
<br />
I'm sure that MAX ignores Text entries
</div>


Can you use IFERROR on the entries in A1:C1 to return zero?

I'm sure that MAX ignores Text entries

Engineer

Saqib Husain

<div>
Thanks both<br />
<br />
Roy,<br />
<br />
I was going to post this formula as it did the job for me <br />
<br />
MAX(IFERROR(A1,0),IFERROR(<wbr />B1,0),IFER<wbr />ROR(C1,0))<wbr /><br />
<br />
but now I have replaced it with your formula.
</div>


Thanks both

Roy,

I was going to post this formula as it did the job for me

MAX(IFERROR(A1,0),IFERROR(B1,0),IFERROR(C1,0))

but now I have replaced it with your formula.

<div>
Pleased to help. I remembered using AGGREGATE in the past for ignoring hidden rows, but it is a very useful Function.
</div>


Pleased to help. I remembered using AGGREGATE in the past for ignoring hidden rows, but it is a very useful Function.

<div>
<div class="content wysiwyg-content">
I need to get the maximum of A1:C1. One or more of the values could be text or error condition. Please give me a formula to ignore the error cells and if all three are error then return a blank.
</div>
</div>


I need to get the maximum of A1:C1. One or more of the values could be text or error condition. Please give me a formula to ignore the error cells and if all three are error then return a blank.

Max() function to circumvent error condition

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.