var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: What is wrong with this formula?
For clarification I want it to add AJ6 + 8. If the total is greater than 480 then 480 remains unchanged and can only be subtracted from.
Your sentence is incomplete. What do you mean by "can only be subtracted from"?
There is plenty wrong with the fomula and, as shades indicated, you requirment is eve less clear.
Are you trying to do this
If not then what ??
I don't think you can use a formula?
For totals upto 480 then give the total
For totals over 480, if the next number in the sum tips it over 480 then still show 480. Then at the next number start counting backwards from 480.
This will need a User Function since the formula doesn't know how many terms are in the sum and at what point the total will be 480.
Unless someone knows different, but it would be one hell of a formula.
If I have some time to spend I will try and get a User Function sorted for you, or someone might beat me to it?
Is this what you are trying to do