Hi all:
I have three possibilities: <=100, >100<=200, >200. Instead of using if statements I remember there is a way to set it up as a table going down. The formula goes down the table, finds where the number fits and goes to the right and picks up whatever is there. (Kind of like a lookup but not quite.
I have looked for an example but can't seem to find one. Any help is appreciated.
Max
Bookmarks