Multiple Formulas in One

Giganews Newsgroups
Subject: Multiple Formulas in One
Posted by:  2604ashleigh
Date: Thu, 29 Jun 2006

Please help.
Want to create a formula that allows for:
1. if amount in cell next to it is less than an amount, to come up as one
amount.
2. if amount in cell next to it is more than an amount, to come up as
another amount,
The difficult bit for myself...
3. if amount in cell next to it is more than another amount on top of that,
to come up as another amount.

If you can help, that would be fantastic.

Replies