Decimal missing in result

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

--
Message posted from http://www.ExcelForum.com

0
9/2/2004 7:34:12 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
289 Views

Similar Articles

[PageSpeed] 37

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

--
Message posted from http://www.ExcelForum.com

0
9/2/2004 10:39:48 PM
AlfD wrote:
> *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


---
Message posted from http://www.ExcelForum.com/

0
9/3/2004 8:49:43 AM
Reply:

Similar Artilces:

Missing context menu
I can no longer get a context menu when I right click on a message line in the window with all the messages listed in my inbox. Microsoft's literature says the Outlook doesn't have the functionality to change how context menus appear. I'm using Outlook 2000, and I liked to get the context menu so I could look at the "options" selection and see all the technical data about the message which would help me identify who sent the message. Have you tried a repair on Office already? -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -Navigati...

SOP NonInventory Unit Cost 6 Decimal Places
Is there any simple way to increase the currency decimal places to greater than the current highest value of 5? Thanx Scott, I don't believe there is any easy or even moderately difficult way to do this, as the field types used to store amounts in GP only go up to 5 decimal places. -- Victoria Yudin Dynamics GP MVP Flexible Solutions - home of GP Reports http://www.flex-solutions.com/gpreports.html blog: http://www.victoriayudin.com "Scott Rutledge" <sersoar@hotmail.com> wrote in message news:E102B81B-8555-400E-843C-240C58794294@microsoft.com... > Is there any...

Missing Options Menu
In Excel 97, when I select Tools -> Options, the Options menu does not appear. I have tried reinstalling with no change. Hello Andy Close Excel Do a search for EXCEL.XLB files on your machine and rename the most recent XLB found with a different extension (eg .OLD) Open Excel Please note that filename may vary according to your operating system. HTh Cordially Pascal "Andy Power" <anonymous@discussions.microsoft.com> a �crit dans le message de news:074601c49591$4e98a680$3501280a@phx.gbl... > In Excel 97, when I select Tools -> Options, the Options > menu does not ...

How do I get the formula to show the result on the worksheet?
The Calculation in Tools is set to automatic & the result of the formula is shown during Function; however, the result of the formula will not show on the worksheet, just the formula itself. Your cell format is set to Text. Change the format of the cell to General. Reenter the formula. In article <0C6E13D8-18FC-4E40-B9AB-86EAB16F2A3B@microsoft.com>, "kanye" <kanye@discussions.microsoft.com> wrote: > The Calculation in Tools is set to automatic & the result of the formula is > shown during Function; however, the result of the formula will not show on ...

VLOOKUP help returning multiple results
I am working with 2 sheets and need to be able find a data match on one sheet and display multiple results on another sheet - here's a simplified version. sheet 1 named Activities, sheet 2 named Calendar Activities sheet will list 100+ activities which will all have a start date. Some activities will have the same start date. And any of the dates may change. Example of Activities sheet: Col 1 Col 2 Start 01-Jan-07 Identify site 05-Feb-07 Enter in database 05-Jan-07 Contact project ldr 01-...

Excel TREND results
I've been using the TREND function in Excel to do curve fitting to some data. The problem I'm having is that I can not find the actual coefficients that make up the 6th. Order Polynomial that fitted the data. I'm looking for something like..... Ax^6 + Bx^5 + Cx^4 + Dx^3 + Ex^2 + Fx + G Where I can used the A, B, C, D, E, F and G coefficients in other formulas. Chris. Hi, Have a look at these pages on the subject of trendlines and formula. http://www.stfx.ca/people/bliengme/ExcelTips/Polynomial.htm http://www.tushar-mehta.com/excel/...

Reduce currency decimals
Hi, Is there any tool which will reduce the currency decimals on our Great Plains system. We want to reduce our system currency decimals. Thank you. KT I'm not sure if this is what you mean, but there's Tools >> Utilities >> Inventory >> Change Decimal Places This utility can change the decimal places for items. I don't know of any system-wide change for decimal places. Eleni "KT" wrote: > Hi, > > Is there any tool which will reduce the currency decimals on our Great > Plains system. We want to reduce our system currency decimals....

Am I missing something on manual duplex?
I have used Word 2003 to produce an A5 booklet....and in the print dialogue there is a "manual duplex" option. Using that, Word kindly prints one side of the page, then it tells me when to remove the paper, turn it over and it prints the reverse. Nice and easy. I can't seem to find the same in Publisher....of course, Publisher being part of the same Office Suite would mean that the dialogues are different to Word! I have downloaded and installed the add-in for duplex printing but that doesn't seem to work half the time....there's no help file anywhere and no walk-throu...

how can I email the results and aviod getting an "Update the sheet?" message?
I have a worksheet containing several sheets many of which are "linked" by formulae embedded in certain cells. Many of the sheets contain a table showing the results. These tables are formatted to have colours etc and to generally "look nice" I often have to email the data tables from only one or two of those sheets but it seems tha twhen the recipients get them and open them, they get a message telling them that the sheets are linked to another source and asking them " do you want to update the cells" (or wording similar to that) Apart from simply cutting and p...

decimal problem
Hi all I a very strange effect when using different decimal settings and calculating some values: DECLARE @Decimal1 decimal(5, 2) DECLARE @Decimal2 decimal(30, 2) SET @Decimal1 = 0.2 SET @Decimal2 = 0.2 SELECT (CONVERT(decimal(15, 15), 0.000000000322900) * (1 - @Decimal1)) SELECT (CONVERT(decimal(15, 15), 0.000000000322900) * (1 - @Decimal2)) The first result is correct (0.00000000025832000), the second is wrong, why ??? Thanks for any comments Best regards Frank Uray Hi Frank This is what happens when you multiple these precision&scales Precision 15 + 3...

IMF Console missing??
Hello i just have one question , simple i hope! I use my pc (windows xp pro SP2) with a custom console to administer my domain , exchange , dns , etc... Everything is working fine. Last month i installed on my exchange , the IMF from microsoft. When i am logging on to my exchange machine localy or through RDC i can see in exchange system manager below SMTP ,the IMF icon and i am able to change setting install filters and so on... When i open my console from my pc and use exchange system manager console (i have installed exchange management tools and sp1) i cannot see IMF icon below SMTP Vitu...

Font missing
I created a document in Publisher and printed it. Opened document a week later and received 'font missing' error message. In the Format...Font dialong box the font's name is there with the word (missing) next to it. Where did it go? Are you using a font manager? Maybe the link was broken. Do you have the font somewhere else on your computer? If so install/re-install it. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "andy" <andy@discussions.microsoft.com> wrote in message news:9390E623-E0FE-498A-AA6...

Scanpst missing
Outlook says there is problem with c:\users\xxx\appdata\local\microsoft\outlook\outlook.pst and to run scanpst.exe. I have Vista and after searching computer cannot find the file. Is there a way to download this file? My computer is french so I don't always knowthe translations It's there. Are you using 64bit vista? if so, office is in the 32 bit programs file. See http://www.outlook-tips.net/beginner/scanpst.htm -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com/ Outlook T...

SAVE SELECTED RESULTS WITH LATCHING
I put a number from 1 to 200 in A1. Excel then takes this number and, using a 2-column look up table in array BA1:BB200, the applicable stock symbol in BB1:BB200 is inserted in E1 and the stock's daily moves are tested for fit to certain criteria that are determined by a complex spreadsheet in E1: AZ 200. I get four outputs like "Squeeze" "Buy alert", "Strong Buy", "Sell alert" and so on, variously, in A2:D2. For symbol #1 I can straightforwardly make the output appear in cells BE1:BH1 but I want to latch them there and automatically go on to the ...

did not return the results.
Hi, I have a big problem with my vista-windows mail.A few days ago, after 5 minutes that I had shut off my computer, in order to check one of my e-mail,I'm started it again.But windows mail gave error and send me error report that the e-mails not working correctly.Since that day,the content of the e-mails,attachments not to be seen when you click any of them.Mean it didn't retun the results.it is a bit urgent.Pls kindly help me. Thanks... Try repairing the database. See www.oehelp.com/WMUTil/ If you still have problems after that, see point 3 here (www.oehelp.c...

Missing Email #4
I am running a 2003 exchange server and one of my users sayes he isn't getting some mail that people say they are sending him. There is a mailbox listed in mailboxes called "Systemmailbox - {GIUD}" there are items listed in there. Could this be the missing mail? And is there anyway to see what these items are. Thanks for any help Damian It won't be in the System Mailbox. The System Mailbox contains schema information. There's generally no reason to ever need to access it unless PSS is instructing you to. As far as your user, make sure that you have message t...

Missing something basic
Working with Access 2003. I have a table of users, their phone numbers, and job classes called tblUsers. A query extracts that information into qryUsers. I have a form that uses the query as the record source called frmUsers. The form only contains a single combobox so someone can select the user for which they wish to view data in other forms. It works fine for the first user on the list in the combobox. Selecting any other user in the combobox causes the first record in the table to change to that user's name. For example: The table and the query both contain: Timmy Bobby ...

Sort by Date and Copy results to another sheet
I'm still working on my little project and can't seem to find what i'm looking for in any of the forums or help files, I know it can be done as I did it a college. using the following data example Date Time Name details 11/03/08 17:00 greg wanted to party 12/03/08 10:55 fred wanted help 13/03/08 11:45 paul wanted to speak to dave 13/03/08 13:30 harry wanted to go home I want to leave the data intact and un edited in the main sheet ...

Decimal
In a laboratory test we do the temperature has to be reported to the nearest 0.5�C. Can anyone let me know how to format it so that when the result is a whole number, it leaves the decimal point out? eg 22�C or 22.5�C (not 22.�C or 22.0�C) Alan "Alan Cocks" <alandrob@netspace.net.au> wrote in message news:btlqhd$19fi$1@otis.netspace.net.au... > In a laboratory test we do the temperature has to be reported to the > nearest 0.5�C. > Can anyone let me know how to format it so that when the result is a whole > number, it leaves the decimal point out? &g...

Missing fields in new email
Hi. I've gone back a few days and looked for an anwer to my problem and didn't find anything, so forgive me if this has been addressed before. When I click on New----->Mail Message the normal new mail window pops up as it should. However, the Subject, CC, and BCC fields are all missing. The only option that is available is the To: field. How can I get it to display the other fields? Thanks. View, Header. -- Patricia Cardoza Outlook MVP www.cardozasolutions.com Author, Special Edition Using Microsoft Outlook 2003 ***Please post all replies to the newsgroups*** "tep1997&qu...

Simple Round call results in Arithmetic overflow
Hi, I'm a bit dazzled why this statement won't work in T-SQL : Select Round(9.990000, 0) The error I get is : Arithmetic overflow error converting expression to data type numeric. The result should be : 10 I've tried this in SQL 2005,2008 and 2008 R2 (Error message if from R2), didn't find anything in BOL either Select ROUND(19.99, 0) works just fine Is this a bug or not? We develop accounting software and for us this is a dangerous bug. Submitted via EggHeadCafe - Software Developer Portal of Choice Assemblies in Folder Debug Build Checker h...

VBA code and decimals
I have some VBA code as this: rrows=lastrow/4 if lastrow is 138 then rrows should be 34.5 but I always get 34(no decimal) How do I fix that Thanks I just did this and got 34.5 Sub lastrowdecimal() lastrow = 138 rrows = lastrow / 4 MsgBox rrows End Sub -- Don Guillett SalesAid Software dguillett1@austin.rr.com "pcor" <pcor@discussions.microsoft.com> wrote in message news:F21838BC-42AA-48A3-9B0C-D2139287A187@microsoft.com... >I have some VBA code as this: > rrows=lastrow/4 > > if lastrow is 138 then rrows should be 34.5 but I always get 34(no > decimal) >...

Missing font in MS Publisher
When I go to use the Palatino font in MS Publisher 2007, it says it is missing. I like it. How can I get it into the program? Thanks, Tom Palatino shipped with Office Pro 2003, Windows 2000, Windows XP -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Thomas Minter" <tminter5@adelphia.net> wrote in message news:47826b11$0$28818$4c368faf@roadrunner.com... > When I go to use the Palatino font in MS Publisher 2007, it > says it is missing. I like it. How can I get it into the program? > > Thanks, > Tom ...

Missing email
Sometimes when I press "sync", I see on the bottom of the screen "1 new message", but that message never shows up in my all inbox folder. Is the email lost? Is this a bug? Did you look in your Junk E-mail folder and Deleted Items folder? --=20 Gary VanderMolen, Microsoft MVP (Mail) Microsoft MVP Program: http://mvp.support.microsoft.com "boss man" <boss man@discussions.microsoft.com> wrote in message = news:20EA3246-8995-42A9-A9EB-354B87049079@microsoft.com... > Sometimes when I press "sync", I see on the bottom of the screen &...

exadmin virtual folder missing after exchange 2003 setup
I'v installed "MS exchange 2003" on "win2003 serv Enterprise". After installation comleted sucessefuly everything works exept web portion is missing. No "exAdmin", "exchange" and ... virtual folders created. Everything looks like in MS "282125 - Error Message Occurs When You Connect to Public Folders". Site Configuration: win2003 server Enterprise (fresh install) + exchange 2003 win2000 server domain controller (exchange5.5) win2000 server domain controller (exchange5.5) ...