David
Thu May 08 10:08:08 CDT 2008
Instead of =IF(SUM(A3:C3)>30,30,SUM(A3:C3)) you could use
=MIN(SUM(A3:C3),30)
and instead of =IF(D3>30,30,D3) you could use =MIN(D3,30)
--
David Biddulph
"Gaurav" <gauravsharma@discussions.microsoft.com> wrote in message
news:uiPqsYRsIHA.4840@TK2MSFTNGP05.phx.gbl...
> If you want Column D (which is the sum of A,B,C) to show 30 if the result
> of the Sum exceeds 30 then use this in Col D.
>
> =IF(SUM(A3:C3)>30,30,SUM(A3:C3))
>
> If you want Col E to show 30 even if Col D exceeds 30 then use this in E
>
> =IF(D3>30,30,D3)
>
> Hope that helps.
>
>
> "arisan" <arisan@discussions.microsoft.com> wrote in message
> news:F3DAF4E4-C851-4181-B4B1-1041F1C02398@microsoft.com...
>>I mean if the sum exceeds 30, i need to keep it around 30... or the sum
>>shuld
>> not be more than 30 i. e Sum<=30
>> --
>> arisan
>>
>>
>> "Gaurav" wrote:
>>
>>> What do you mean by 'if it exceeds'?
>>>
>>>
>>> "arisan" <arisan@discussions.microsoft.com> wrote in message
>>> news:BD8F5C2F-BE57-438F-B3C6-564EEAF5676D@microsoft.com...
>>> > hi there!!
>>> > Am New to this discussion and its this problem that brought me to this
>>> > discussion....
>>> >
>>> > its have got to adjust values in Col E to 30, if it exceeds in Col D
>>> > where
>>> > Col D is sum of A, B and C..... tried alot of rubbish formulae but all
>>> > in
>>> > vain...
>>> > can anyone help plz
>>> > --
>>> > arisan
>>>
>>>
>>>
>
>