hi

Product Line Expenses$ Charged % Charged $

1..Product-A 500.50 20% $100.10
2..Product-B 500.50 15% $75.08
3..Product-C 500.50 23% $115.12
4..Product-D 500.50 42% $210.21
Total 100% $500.50


In above data i need to keep the constant value of decimals to 0.50 or
nearest integer instead fof each value instead of .10 .08, .12, or .
21.

My required data should be as under

i.e. in line no. 1 the charged amount is $100.10 but i need 100 or
100.50 similary in line no.2 the charged amount is 75.08 but i need
75 or 75.50.


When i tried to use round function but it does not match the total
value for example the total value is $500.50 but round function gives
$5001 or or $499.50

Any advice will be strongly welcome to reconcile with total value
along with constant decimals of .50 or nearest integer.

regards

Essa

try this

=FLOOR(B2*C2,1)



On Oct 23, 10:24*am, Esssa wrote:
hi

* Product Line * Expenses$ * * *Charged % * Charged $

1..Product-A * * 500.50 20% * * * *$100.10
2..Product-B * * 500.50 15% * * * * *$75.08
3..Product-C * * 500.50 23% * * * *$115.12
4..Product-D * * *500.50 * * * *42% * * * *$210.21
* *Total * * * * * * * * * * * * * * * 100% * * * * $500.50

In above data i need to keep the constant value of decimals to 0.50 or
nearest integer instead fof each value instead of .10 *.08, .12, or .
21.

My required data should be as under

i.e. in line no. 1 the charged amount is $100.10 but i need 100 or
100.50 *similary in line no.2 the charged amount is 75.08 but i need
75 or 75.50.

When i tried to use round function but it does not match the total
value for example the total value is $500.50 but round function gives
$5001 or or $499.50

Any advice will be strongly welcome to reconcile with total value
along with constant decimals of .50 or nearest integer.

regards

Essa

Hi Essa,

Your post is a little confusing but maybe this,
=ROUND(B2*C2/0.5,0)*0.5

HTH
Martin

"Esssa" wrote in message
...

hi

Product Line Expenses$ Charged % Charged $

1..Product-A 500.50 20% $100.10
2..Product-B 500.50 15% $75.08
3..Product-C 500.50 23% $115.12
4..Product-D 500.50 42% $210.21
Total 100% $500.50


In above data i need to keep the constant value of decimals to 0.50 or
nearest integer instead fof each value instead of .10 .08, .12, or .
21.

My required data should be as under

i.e. in line no. 1 the charged amount is $100.10 but i need 100 or
100.50 similary in line no.2 the charged amount is 75.08 but i need
75 or 75.50.


When i tried to use round function but it does not match the total
value for example the total value is $500.50 but round function gives
$5001 or or $499.50

Any advice will be strongly welcome to reconcile with total value
along with constant decimals of .50 or nearest integer.

regards

Essa

Look up the MROUND function in Excel help.
--
David Biddulph

"Esssa" wrote in message
...

hi

Product Line Expenses$ Charged % Charged $

1..Product-A 500.50 20% $100.10
2..Product-B 500.50 15% $75.08
3..Product-C 500.50 23% $115.12
4..Product-D 500.50 42% $210.21
Total 100% $500.50


In above data i need to keep the constant value of decimals to 0.50 or
nearest integer instead fof each value instead of .10 .08, .12, or .
21.

My required data should be as under

i.e. in line no. 1 the charged amount is $100.10 but i need 100 or
100.50 similary in line no.2 the charged amount is 75.08 but i need
75 or 75.50.


When i tried to use round function but it does not match the total
value for example the total value is $500.50 but round function gives
$5001 or or $499.50

Any advice will be strongly welcome to reconcile with total value
along with constant decimals of .50 or nearest integer.

regards

Essa