Multiple nested if statements

Giganews Newsgroups
Subject: Multiple nested if statements
Posted by:  amanda
Date: Sun, 14 Jan 2007

Hi,

I have a list of 10 possible categories of debt, i.e:

A 0 - 100
B 101 - 200
C 201 - 300
D 301 - 400
E 401 - 500 etc.

I also have a list of debts, by invoice, with varying amounts, i.e:

Invoice 1 $159
Invoice 2 $345
Invoice 3 $677

Against the invoice I want to add the category it falls into, i.e A,B,C etc.
Because there are 10 categories there are too many to use =if(.... how can I
do this?

Thank you

Amanda

Replies