Sum of Calculation in single Cell

Re: Sum of Calculation in single Cell

Hi GIRISHBISHT
With the smaller record sets its better to generate a table and write the request with in the thread.
Or at least explain the request in the thread
[table="class:thin_grid"]

[tr][td]

v

[/td]

[td="bgcolor:#ECF0F0, align:center,width:64"]A[/td]
[td="bgcolor:#ECF0F0, align:center,width:64"]B[/td]
[td="bgcolor:#ECF0F0, align:center,width:110"]C[/td]
[td="bgcolor:#ECF0F0, align:center,width:62"]D[/td]

[/tr][tr]

[td="bgcolor:#ECF0F0, align:center"]1[/td]
[td="bgcolor:#D9D9D9, align:LEFT"][COLOR="#000000"]Month[/COLOR][/td]
[td="bgcolor:#D9D9D9, align:LEFT"][COLOR="#000000"]SALE[/COLOR][/td]
[td="bgcolor:#D9D9D9, align:LEFT"][COLOR="#000000"]Value B or Max 250[/COLOR][/td]
[td="bgcolor:#D9D9D9, align:LEFT"][COLOR="#000000"]Tax[/COLOR][/td]

[/tr]

[tr]

[td="bgcolor:#ECF0F0, align:center"]2[/td]
[td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Jan[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]227[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]227[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]4[/COLOR][/td]

[/tr]

[tr]

[td="bgcolor:#ECF0F0, align:center"]3[/td]
[td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Feb[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]594[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

[/tr]

[tr]

[td="bgcolor:#ECF0F0, align:center"]4[/td]
[td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Mar[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]510[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

[/tr]

[tr]

[td="bgcolor:#ECF0F0, align:center"]5[/td]
[td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Apr[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]606[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

[/tr]

[tr]

[td="bgcolor:#ECF0F0, align:center"]6[/td]
[td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]May[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]503[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

[/tr]

[tr]

[td="bgcolor:#ECF0F0, align:center"]7[/td]
[td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Jun[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]176[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]176[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]4[/COLOR][/td]

[/tr]

[tr]

[td="bgcolor:#ECF0F0, align:center"]8[/td]
[td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Jul[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]368[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

[/tr]

[tr]

[td="bgcolor:#ECF0F0, align:center"]9[/td]
[td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Aug[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]485[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

[/tr]

[tr]

[td="bgcolor:#ECF0F0, align:center"]10[/td]
[td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Sep[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]403[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

[/tr]

[tr]

[td="bgcolor:#ECF0F0, align:center"]11[/td]
[td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Oct[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]148[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]148[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]3[/COLOR][/td]

[/tr]

[tr]

[td="bgcolor:#ECF0F0, align:center"]12[/td]
[td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Nov[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]775[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

[/tr]

[tr]

[td="bgcolor:#ECF0F0, align:center"]13[/td]
[td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Dec[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]980[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

[/tr]

[tr]

[td="bgcolor:#ECF0F0, align:center"]14[/td]
[td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Total[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5775[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]2801[/COLOR][/td]
[td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]56[/COLOR][/td]

[/tr]

[/table]
sum of range D2 (to D13) [COLOR="#0000CD"]=ROUNDUP(C2*1.75%,0)[/COLOR]
I need a formula in single cell to get the result as D14 = 56

Re: Sum of Calculation in single Cell

Oh
expand array formula
[COLOR="#0000CD"]=SUM(ROUNDUP(IF(B2:B13<=250,B2:B13,250)*0.0175,0))[/COLOR] C+S+E

Re: Sum of Calculation in single Cell

LOL
bit long