Decimal missing in result

  • Thread starter Thread starter barilla
  • Start date Start date
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
 
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
 
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 *

1. yes but not fix it

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

Ciao
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top