Tidy up a formula!
Posted by Richard Larocque on January 09, 2002 8:36 PM
I really don't have a problem,, because I have the results I'm looking for, however I'm wondering if I can improve on the following:
I have a large database with 9500 rows. In column A, I have the following:
In column B, I have numerical values.
In column C I wrote the formula:
In column D I wrote the formula:
In column E I have the following:
The result that is desired is finally achieved in column E.
Now instead of using three columns to get the desired result, can it be done in one combined formula?