 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008Exceel 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  Signaturearisan 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)) > hi there!! > Am New to this discussion and its this problem that brought me to this [quoted text clipped - 6 lines] > -- > arisan What do you mean by 'if it exceeds'? > hi there!! > Am New to this discussion and its this problem that brought me to this [quoted text clipped - 4 lines] > vain... > can anyone help plz 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 Signaturearisan > What do you mean by 'if it exceeds'? > [quoted text clipped - 6 lines] > > vain... > > can anyone help plz 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. >I mean if the sum exceeds 30, i need to keep it around 30... or the sum >shuld [quoted text clipped - 12 lines] >> > vain... >> > can anyone help plz 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 > 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. [quoted text clipped - 23 lines] >>> > vain... >>> > can anyone help plz |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.