I've created a work book with 4 pages.
1st one has a form that when data (number) is entered in one box, anohter
box needs to show a dollar figure based on data linked from one of the 3
other sheets.
The calculation needs to sum a total and return that value to the form (1st)
page.
ex. 1st box can only be 1 to 4: 4 entered 2nd box : 3rd box and 4th box
returns calculated amount from one of 3 other sheets.

Data entered on 2nd line must be between 5-20: 2nd 3rd & 4th box: returns
calculated amount as above.

Data entered on 3rd line must be between 21-84: 2nd 3rd & 4th box: returns
calculated amount as above.

Data entered on 4th line must be between 85-340: (as above)

Data entered on 5th line must be between 341-1364: (as above)

Data entered on 6th line must be between 1365-5460: (as above)

I have attempted to use just about every function.

I can get a value to return that just adds the range of values, regardless
of the value input in the 1st box what i can't seem to figure out how to ask
in formula for a value to be returned that is calculated (dependant) on the
value entered in the first box.

Any help / guidance would be greatfully appreciated.

John