| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exceel formulae
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Exceel formulae
It sounds like you want to have the sum in column D show the actual
sum unless that value exceeds 30. If so, the formula would be: =IF(SUM(A3:D3)30,30,SUM(A3:D3)) On May 8, 9:49 am, arisan wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Exceel formulae
What do you mean by 'if it exceeds'?
"arisan" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Exceel formulae
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" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Exceel formulae
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(D330,30,D3) Hope that helps. "arisan" wrote in message ... 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" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Exceel formulae
Instead of =IF(SUM(A3:C3)30,30,SUM(A3:C3)) you could use
=MIN(SUM(A3:C3),30) and instead of =IF(D330,30,D3) you could use =MIN(D3,30) -- David Biddulph "Gaurav" wrote in message ... 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(D330,30,D3) Hope that helps. "arisan" wrote in message ... 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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
| Formulae | Excel Worksheet Functions | |||
| formulae | Excel Discussion (Misc queries) | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
| Exceel Links (Another One !!) | Links and Linking in Excel | |||
Linear Mode
