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