Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

nested functions problems

Status
Not open for further replies.

bonz39

IS-IT--Management
Apr 11, 2005
1
US
hello all, i have been using approach for about 5 years, and i can usually get it to do what i want, except for now. i need a calculation to create off a nested if statement, (i think). it goes like this. if total <500, 1.19,>500<600, 2.38, >600 <700, 3.57, and so on up to 2500, 47 different greater than less than computations. is this possible? i have spent hours trying to get this to work, with no luck. any help or suggestions would be greatly appriciated. thanks in advance.
maybe i could pull from a table or something, i am totally confused....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top