how to round a formula in excel

[rubusmubu]

I am trying to post this formula "=(E10-C10)*1.5%+900" I need result should be rounded to nearest number! How can I do that?!

[Phuocam]

Try this ...
=ROUND((E10-C10)*1.5%+900,0)

[rubusmubu]

it's not working actually if I get like 945.36 as result I want it to show 945.00 / 946.00 changing in format only made 945 so it's look ugly

[Phuocam]

result 946:
=ROUNDUP((E10-C10)*1.5%+900,0)
result 945.00 / 946.00:
=TEXT(ROUNDDOWN((E10-C10)*1.5%+900,0),"0.00")&" / "&TEXT(ROUNDUP((E10-C10)*1.5%+900,0),"0.00")

[rubusmubu]

Tx it's worked I might have done some mistake before Great

[Sam Capricci]

maybe this... =--TEXT(ROUND((E10-C10)*1.5%+900,0),"0.00")

[ZaLdY]

Can not be done, in math we can only round .5 .6 .7 .8 .9 but not .1 .2 .3. .4. Do it manualy.