Decimal missing in result

B

barilla

In this formulas the result is whithout decimal...Why?

=SE(R3=1;$P$3/100*U3;SE(R3=2;$P$3/100*U3;SE(R3=3;$P$3/100*U3;SE(R3=4;$P$3/100*U3;))))&SE(R3=5;(SE(T3>=$P$3;T3/100*U3;0));"")&SE(R3=6;(SE(T3>=$P$3;T3/100*U3;0));"")&SE(R3=7;(SE(T3>=$P$3;T3/100*U3;0));"")&SE(R3=8;(SE(T3>=$P$3;T3/100*U3;0));"")&SE(R3=9;T3/100*U3;SE(R3=10;T3/100*U3;SE(R3=11;T3/100*U3;SE(R3=12;T3/100*U3;))))&SE(R3=13;$P$3/100*U3;SE(R3=14;$P$3/50*U3;SE(R3=15;$P$3/100*U3;SE(R3=16;$P$3/100*U3;))))&SE(R3=17;(SE(T3>=$P$3;T3/100*U3;0));"")&SE(R3=18;(SE(T3>=$P$3;T3/100*U3;0));"")&SE(R3=19;(SE(T3>=$P$3;T3/100*U3;0));"")&SE(R3=20;(SE(T3>=$P$3;T3/100*U3;0));"")&SE(R3=21;T3/100*U3;SE(R3=22;T3/100*U3;SE(R3=23;T3/100*U3;SE(R3=24;T3/100*U3;))))&SE(R3=25;+T3;SE(R3=26;+T3;))

SE=IF

FOR EXAMPLE: RESULT TO BE TO "12345,67" BUT IT IS "12345"

Excuseme for my english

Cia
 
A

AlfD

Ciao!

1. Have you checked the formatting of the cell which shows the result
Is it set to show 2 decimal places?

2. What is SE? If it is a user-defined function, does it remove th
decimal places?

Al
 
B

barilla

AlfD said:
*Ciao!

1. Have you checked the formatting of the cell which shows the
result? Is it set to show 2 decimal places?

2. What is SE? If it is a user-defined function, does it remove the
decimal places?

Alf *
Click to expand...

1. yes but not fix it

2. SE = (IF) in Excel Italian version language

Ciao
 
Top