Help to condense a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a better way to express the following formula?
I'm in the process of upgrading an old spreadsheet and will have to increase
the future range in a more efficient manner than stated, but am having
trouble!

=IF(AND(ISNUMBER(Y679),ISNUMBER(Y680),ISNUMBER(Y681),ISNUMBER(Y682),ISNUMBER(Y683),ISNUMBER(Y684),ISNUMBER(Y685),ISNUMBER(Y686),ISNUMBER(Y687),ISNUMBER(Y688)),Y679+Y680+Y681+Y682+Y683+Y684+Y685+Y686+Y687+Y688,"not available")

TIA
 

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

Back
Top