need help plz
 

Greetings:

I have a problem that i know there must be an easy solution for...but i have
searched and cannot find it. I need a formula/conditional that will return
actual value if <25 but cap the range at 25 if value is = 25. eg. MY range
is j4:j27 and the sum is in j28. Any help will be appreciated. and more info
will be provided if needed.
thanks
hygeenx

need help plz
 

=MIN(SUM(J4:J27),25)
--
David Biddulph

"Hygeenx" wrote in message
...
Greetings:

I have a problem that i know there must be an easy solution for...but i
have
searched and cannot find it. I need a formula/conditional that will
return
actual value if <25 but cap the range at 25 if value is = 25. eg. MY
range
is j4:j27 and the sum is in j28. Any help will be appreciated. and more
info
will be provided if needed.
thanks
hygeenx

need help plz
 

If you are talking about the sum of J4 to J27 then you can use the formula

=If(Sum(J4:J27)24,25,Sum(J4:J27))

"Hygeenx" wrote:

Greetings:

I have a problem that i know there must be an easy solution for...but i have
searched and cannot find it. I need a formula/conditional that will return
actual value if <25 but cap the range at 25 if value is = 25. eg. MY range
is j4:j27 and the sum is in j28. Any help will be appreciated. and more info
will be provided if needed.
thanks
hygeenx

need help plz
 

Both worked and I am indebted to you guys... thanks a lot.
Hygeenx

"akphidelt" wrote:

If you are talking about the sum of J4 to J27 then you can use the formula

=If(Sum(J4:J27)24,25,Sum(J4:J27))

"Hygeenx" wrote:

Greetings:

I have a problem that i know there must be an easy solution for...but i have
searched and cannot find it. I need a formula/conditional that will return
actual value if <25 but cap the range at 25 if value is = 25. eg. MY range
is j4:j27 and the sum is in j28. Any help will be appreciated. and more info
will be provided if needed.
thanks
hygeenx