Decimals Constant to 0.50 or Nearest Integer

[Esssa]

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

 

[muddan madhu]

try this

=FLOOR(B2*C2,1)

 

[MartinW]

Hi Essa,

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

HTH
Martin

 

[David Biddulph]

Look up the MROUND function in Excel help.