how to get the result with two decimals rounded off

[sumesh56]

i want to get the result in two decimals .the present formula gives the result with one decimal. how can i do this? thanks. pls see the attached file.

original formula is=IF(S6>0,S6*100/600," ")


i have tried with this one-=ROUND(IF(S6>0,S6*100/600," "),2)


FOR some unknown reason this formula is not working.

[maym]

error downloading your file...

[maym]

your second formula should work. Are you able to upload your workbook again? What result do you get?

[bebo021999]

See my guidance in below youtube link:
https://www.youtube.com/watch?v=-AUt...-yd5FEneBt75Fa

[sumesh56]

thanks bebo21999.
but this idea i know and have quoted under my attachement file. something else i wanted

[sumesh56]

your second formula should work. Are you able to upload your workbook again? What result do you get?

thanks for the try. here is the file again uploaded for you.

[davsth]

You either have to format the cells (via the toolbar or otherwise) or which I wouldn't advise enclose the formula in a text function so K1 would be =TEXT(IF(J1>0,J1*100/480," "),"0.00") but to get the 2 decimal places you have made it text, which then will not sum in calculations.

I cant see the problem of formatting the column

Rounding changes the underlying number
formating changes the way any number is displayed

[FDibbins]

Why not just change the formatting to show 2 decimals?
I dont really understand what the problem is here?

[sumesh56]

thanks davsth for the suggestion. it is too complicated. i will go by the formatcells option.

[sumesh56]

thanks fdibbins for the suggestion. there is no porblem in selecting the cells - format cells option-select numbers-resstrict the decimals to two-done. but i thought something else could be coming easier than this one.

[JeteMc]

To avoid getting the #VALUE error when the corresponding entry in column J is zero, modify your second formula to read:

Please Login or Register  to view this content.

Let us know if you have any questions.

[Jonmo1]

I'm shocked it took 11 posts to come up with this answer.

=IF(S6>0,ROUND(S6*100/480,2)," ")

The original
=ROUND(IF(S6>0,S6*100/600," "),2)
The reason this gives #Value! errors is because when the IF is FALSE, it returns " "
That's a TEXT string
ROUND(textstring,2) = Error. How do you round a text string ??

So you have to apply the round to the actual mathematical calculation instead of on the result of the IF.