On Sun, 3 Aug 2008 14:13:00 -0700, BruceK
wrote:

I need help figuring out a formula? Here is what I want to do

I want one cell to add up a column and if that number dosent reach 40 then
it takes more away from another cell but it only displays the 40 or lower and
then anything over the 40 will be displayed in another cell


Please explain in more detail.
Give an example of input and expected output.

How many cells are involved in this?

Are the firstly mentioned "another cell" the same cell as the secondly
mentioned "another cell".?

What do you mean by "it takes more away"?

Lars-Åke