help with the syntax for using range name in a formula?

  • Thread starter Thread starter BRC
  • Start date Start date
B

BRC

I have --------=+AVERAGE(SMALL(B7:B19,{1,2,3}))-------------. I want
to replace B7:B19 with “Myrange” but I can’t seem to get the syntax
right. excel says error in formula. Thks in advance for any help BRC
 
Hi

=AVERAGE(SMALL(Myrange,{1,2,3}))

have you created Myrange?
have you spelt it correctly?
--
Regards
Roger Govier

BRC said:
I have --------=+AVERAGE(SMALL(B7:B19,{1,2,3}))-------------. I want
to replace B7:B19 with “Myrange” but I can’t seem to get the syntax
right. excel says error in formula. Thks in advance for any help BRC

__________ Information from ESET Smart Security, version of virus
signature database 4756 (20100109) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Hi

=AVERAGE(SMALL(Myrange,{1,2,3}))

have you created Myrange?
have you spelt it correctly?
--
Regards
Roger Govier







__________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

Thank you Roger, I thought range name had to be in quotes and needed
something like...... range.("myrange")...Thk again BRC
 
Back
Top