Execl Help - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 10-02-2005, 09:18 PM   #1 (permalink)
Ultra Techie
 
Join Date: Jan 2004
Posts: 769
Default Execl Help

Hello,

I need some help with a Spreadsheet problem, so anyone with good knowledge please help me.

When i enter "=Range(A1:A5)" i get "#Name?"

A1 and A5 been cell positions
__________________

__________________
Sprooty is offline  
Old 10-02-2005, 09:22 PM   #2 (permalink)
It's all just 1s and 0s
 
office politics's Avatar
 
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN to office politics
Default

what cell are you entering this formula into?

name usually means a bad cell reference. this could be a circular cell reference though
__________________

office politics is offline  
Old 10-02-2005, 09:36 PM   #3 (permalink)
Ultra Techie
 
Join Date: Jan 2004
Posts: 769
Default

I have uploaded it to the web so you can have a look.

http://www.savefile.com/files.php?fid=7623800

If you type "=RANGE(B7:K7)" in cell P7 it will give u "#NAME?" instead of the answer.
__________________
Sprooty is offline  
Old 10-02-2005, 10:13 PM   #4 (permalink)
It's all just 1s and 0s
 
office politics's Avatar
 
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN to office politics
Default

i dont see range in my function list. im using openoffice though. goto insert | function and try to find it, but ill bet its not there
office politics is offline  
Old 10-02-2005, 10:16 PM   #5 (permalink)
Ultra Techie
 
Join Date: Jan 2004
Posts: 769
Default

Hmm, thanks ill have a look and see if theres another command that means range..
__________________
Sprooty is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 09:12 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.