Thread: If 45.320% exists, how to cut off zero digit

I've got a formula in which I will display three decimal places unless the 3rd decimal place is a zero (after rounding the 4th decimal up: i.e. 45.3199 becomes 45.320). If the third decimal is a zero, I'll only want it to display the 45.32 instead of the the 45.320. Make sense?

Is there a way to do this within excel without using VBA or do I need to program it?

Any help would be great! thanks!
Curbster

P.S.~ see attached

Hello curbster,

Maybe you could use something like:

=IF(G5="","",IF(ROUNDUP(G5,4)<>"",ROUNDUP(G5,5)*100,""))

See Sheet 1 of WorkBook attached, and also check the changed formula in Cell "C45"

Good Luck!

Hello Winon,
I apologize for the late responce, I checked back a few days after I posted it and couldn't find my post so I figured it didn't go through and forgot about it until now.

Anyway, that's not exactly what I was looking for but its closer than what I had. Lets say A+B=C; if the value in C's digit in the thousanths place is a zero after rounding, drop the zero.

I don't have the luxury of adding another box, say D so that once I get the answer, I could have another box with just the formula. So I would need the formula to calculate, round, and then drop the zero in one clean swoop. Is that better explained? Hope so!

Thanks for your help, and now I know my post went through, I'll check more often!
Curbster

A number format of 0.00#% or 0.00?% will hide the extra 0.