Decimals Constant to 0.50 or Nearest Integer
 

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

Decimals Constant to 0.50 or Nearest Integer
 

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

Decimals Constant to 0.50 or Nearest Integer
 

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

Decimals Constant to 0.50 or Nearest Integer
 

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