YAY - that worked - Thanks Anne!!
"Anne Troy" wrote:
=min(a2:d2)+e2
************
Anne Troy
www.OfficeArticles.com
"Kim" wrote in message
...
I have a row with class grades in it and I want to be able to automatically
find the lowest grade and add the bonus points to it.
Ex: Column A - 85 Column B - 98 Column C - 75 Column D - 100 Column
E
- 5
I want the formula to find Column C as the lowest number and add Column E
to
it (the 5 points) so Column C will now read 80 instead of 75.
Any help? Thanks!