J
Jarle
Hi.
I need to print out different number of decimals depending of cell value. If
the value is <= 0.30 it should print out 2 decimals. If the value is greater
it should have 1 decimal. This works by if/round formula. But if the last
decimal is zero excel ignores it. How can I make this work?
I tried to write a custom setting for cells, but then I got 0.00 in my empty
cells.
Custom setting [>0,3]#0,0;[<=0,3]#0,00 (I use Norwegian decimal point ie ,)
excel then slaps on ;Standard at the end of the setting.
I need to print out different number of decimals depending of cell value. If
the value is <= 0.30 it should print out 2 decimals. If the value is greater
it should have 1 decimal. This works by if/round formula. But if the last
decimal is zero excel ignores it. How can I make this work?
I tried to write a custom setting for cells, but then I got 0.00 in my empty
cells.
Custom setting [>0,3]#0,0;[<=0,3]#0,00 (I use Norwegian decimal point ie ,)
excel then slaps on ;Standard at the end of the setting.