Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default How do you set up range names, name formulas

Help,

I need to accuratley create a range of "currancey numbers, name a formula
that tests for a value of ($68), TRUE, returns a sum calculation; FALSE
retests the logical value for a different amout ($236). TRUE also returns a
specific value. False test the logial expression for a new value and so on
down the range until it meets the final,"FALSE", which should return an
"Invalid Entry" notice.

To be real honest, I have no idea what I'm missing here, but the assigned
name always to tresolves to the alaphabetically first name in the the names
list

I know that I'm missing the forrest for the trees, but I don't seem to be
able to be reason out the process to create, define, and applly names
correctley.


--
Don


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How copy a range o cells without adjusting formulas? Oliver Excel Discussion (Misc queries) 4 September 3rd 06 12:44 AM
Hidden Range Names [email protected] Excel Worksheet Functions 3 August 28th 06 04:12 PM
dynamic range name Jonathan Cooper Excel Discussion (Misc queries) 6 April 6th 06 09:58 PM
Sorting names in a range John S Excel Worksheet Functions 2 April 4th 05 06:36 AM
Range Names wal50 Excel Worksheet Functions 3 November 27th 04 12:49 AM


All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"