Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How copy a range o cells without adjusting formulas? | Excel Discussion (Misc queries) | |||
Hidden Range Names | Excel Worksheet Functions | |||
dynamic range name | Excel Discussion (Misc queries) | |||
Sorting names in a range | Excel Worksheet Functions | |||
Range Names | Excel Worksheet Functions |