|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 30th, 2006, 08:14 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The same IF (SE) formula give me two different number: why???
The same IF (SE) formula give me two different number: why???
Hi, please help me to understund why this formula it wrong download this (45kb) Your download link: http://www.easy-sharing.com/538860/TN2.xls.html look at calc/B3 and calc2/B3 you find the SAME formula with the SAME data but the result it's different!!!!!! Why? I come to be creazy (sorry my bad English) -- ^__^ o.g.a.v.o.s. [Onorevoli Grazie A Voi Ohhh Saggi] 
|
|
#2
June 30th, 2006, 09:42 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
The same IF (SE) formula give me two different number: why???
Hi Luca,
Your right! It does drive you crazy. I can't find any reason for this to happen. When I recreated this situation in a new workbook they worked perfectly. So that's all I can suggest just delete that workbook with it's strange faults and start again. HTH Martin
|
|
#3
June 30th, 2006, 09:53 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
The same IF (SE) formula give me two different number: why???
PS If anyone is concerned about clicking on the download
link, I clicked on it when it was showing zero downloads, played with the file for about half an hour and have had no problems whatsoever. Regards Martin
|
|
#4
June 30th, 2006, 12:33 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
The same IF (SE) formula give me two different number: why???
Hi Martin, look what's Lykos tell to me....
----- Original Message ----- From: G Lykos Newsgroups: microsoft.public.excel.programming Sent: Friday, June 30, 2006 10:32 AM Subject: The same IF (SE) formula give me two different number: why??? This has to do with working in Lotus 123 format. To resolve the apparent issue with tab 'calc' - with that tab selected, go to Tools | Options | Transition, and uncheck 'Transition formula evaluation'. The formulas will then display the expected values. Cheers! "MartinW" ha scritto nel messaggio ... Hi Luca, Your right! It does drive you crazy. I can't find any reason for this to happen. When I recreated this situation in a new workbook they worked perfectly. So that's all I can suggest just delete that workbook with it's strange faults and start again. HTH Martin
|
|
#5
June 30th, 2006, 12:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
The same IF (SE) formula give me two different number: why???
Sorry i dont understand what wrong (cause i dont read English very well....)
^__^ "MartinW" ha scritto nel messaggio ... PS If anyone is concerned about clicking on the download link, I clicked on it when it was showing zero downloads, played with the file for about half an hour and have had no problems whatsoever. Regards Martin
|
|
#6
June 30th, 2006, 01:30 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
The same IF (SE) formula give me two different number: why???
Tools|Options|transition Tab|Uncheck "transition formula evaluation"
Do it for all your sheets in the workbook. -= Luca =- wrote: The same IF (SE) formula give me two different number: why??? Hi, please help me to understund why this formula it wrong download this (45kb) Your download link: http://www.easy-sharing.com/538860/TN2.xls.html look at calc/B3 and calc2/B3 you find the SAME formula with the SAME data but the result it's different!!!!!! Why? I come to be creazy (sorry my bad English) -- ^__^ o.g.a.v.o.s. [Onorevoli Grazie A Voi Ohhh Saggi] -- Dave Peterson
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Return SEARCHED Column Number of Numeric Label and Value | Sam via OfficeKB.com | Worksheet Functions | 23 | January 30th, 2006 06:16 PM |
| Microsoft Access Limits (file size, table records, users) | Mike | General Discussion | 4 | November 4th, 2005 03:01 AM |
| Formula checking multiple worksheets | sonic-the-mouse | Worksheet Functions | 11 | June 6th, 2005 06:37 PM |
| Number of objects | thomak | General Discussion | 3 | February 17th, 2005 11:58 AM |
| What formula will give me a result if an odd number appears in a c | JulieD | Worksheet Functions | 2 | September 13th, 2004 04:50 PM |
Linear Mode
