Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula>}"
=A5
if you know that A1:A5 will have numbers in it.
=lookup(1E+100,A1:A5)
will return the last number in A1:A5.
=if(count(a1:a5)=0,"no numbers",lookup(1E+100,A1:A5))
will check to see if there's at least one number in the range.
1E+100
is scientific notation for a big number: 1 followed by 100 0's.
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.