Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|