Omitting #n/a from calculations

  • Thread starter Thread starter archanapatelwhite
  • Start date Start date
A

archanapatelwhite

Hi
I need help omitting #n/a from calculations
ie is A1 = 3, A2 = 4, A3 = #n/a and A4 = 5 and I do the calculation
min(A1:A4) i want it to come up with 3 not #n/a...
can anyone help?
Cheers
 
=Min(if(isnumber(A1:A4),A1:A4))

Entered with Ctrl+Shift+Enter rather than just enter since this is an array
formula.
 
Thanks Tom, much appreciated..

=Min(if(isnumber(A1:A4),A1:A4))

Entered with Ctrl+Shift+Enter rather than just enter since this is an array
formula.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Linest function for polynomial regression on horizontal range 0
Scrabble Value calculation for Welsh words 0
Excel =SUM(A1=A1+B1) 0
Removing Sequential Numbers 4
#N/A Conversion 8
use macro to copy formula with value and not formula without value 3
Supressing a #VALUE! error returned? 3
Macro that analyses 3 columns and put results in 4th 5

Back
Top