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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |