| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'm having a really strange problem with 3 if statements.
They are basically the same statement only the false statement is different
but all the cells false statement formula are correct the first statement returns "0" regardless, the second the correct amount and the third "0". I have tried moving the formula to different cell and the same thing happens. Marc |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'm having a really strange problem with 3 if statements.
So where are the statements?
-- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Marc" wrote in message . net... They are basically the same statement only the false statement is different but all the cells false statement formula are correct the first statement returns "0" regardless, the second the correct amount and the third "0". I have tried moving the formula to different cell and the same thing happens. Marc |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'm having a really strange problem with 3 if statements.
Here are the 3 statements out of 3 copies of the same workbook the first set
of three works the others do not. =IF(B26+B27+B28=0,0,(G46+G72+G98+G124)) =IF(B26+B27+B28=0,0,(E45+E71+E97+E123)) =IF(B26+B27+B28=0,0,(G45+G71+G97+G123)) =IF(B26+B27+B28=0,0,(G46+G72+G98+G124)) =IF(B26+B27+B28=0,0,(E45+E71+E97+E123)) =IF(B26+B27+B28=0,0,(G45+G71+G97+G123)) =IF(B26+B27+B28=0,0,(G46+G72+G98+G124)) =IF(B26+B27+B28=0,0,(E45+E71+E97+E123)) =IF(B26+B27+B28=0,0,(G45+G71+G97+G123)) Maybe I've looked at this to long but they look identical Marc "Peo Sjoblom" wrote in message ... So where are the statements? -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Marc" wrote in message . net... They are basically the same statement only the false statement is different but all the cells false statement formula are correct the first statement returns "0" regardless, the second the correct amount and the third "0". I have tried moving the formula to different cell and the same thing happens. Marc |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'm having a really strange problem with 3 if statements.
They definitely return the same result for me if I play around with some
numbers, no difference at all What happens if you press F9? Are they on the same sheet? -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Marc" wrote in message nk.net... Here are the 3 statements out of 3 copies of the same workbook the first set of three works the others do not. =IF(B26+B27+B28=0,0,(G46+G72+G98+G124)) =IF(B26+B27+B28=0,0,(E45+E71+E97+E123)) =IF(B26+B27+B28=0,0,(G45+G71+G97+G123)) =IF(B26+B27+B28=0,0,(G46+G72+G98+G124)) =IF(B26+B27+B28=0,0,(E45+E71+E97+E123)) =IF(B26+B27+B28=0,0,(G45+G71+G97+G123)) =IF(B26+B27+B28=0,0,(G46+G72+G98+G124)) =IF(B26+B27+B28=0,0,(E45+E71+E97+E123)) =IF(B26+B27+B28=0,0,(G45+G71+G97+G123)) Maybe I've looked at this to long but they look identical Marc "Peo Sjoblom" wrote in message ... So where are the statements? -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Marc" wrote in message . net... They are basically the same statement only the false statement is different but all the cells false statement formula are correct the first statement returns "0" regardless, the second the correct amount and the third "0". I have tried moving the formula to different cell and the same thing happens. Marc |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'm having a really strange problem with 3 if statements.
No their in three different spread sheets but all are copies of the master.
I've C&P the formulas to different cells and they don't work and I've C&P the formula from the sheet that works to the ones that don't and they don't work. Could the workbook have become corrupted in some way? Marc "Peo Sjoblom" wrote in message ... They definitely return the same result for me if I play around with some numbers, no difference at all What happens if you press F9? Are they on the same sheet? -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Marc" wrote in message nk.net... Here are the 3 statements out of 3 copies of the same workbook the first set of three works the others do not. =IF(B26+B27+B28=0,0,(G46+G72+G98+G124)) =IF(B26+B27+B28=0,0,(E45+E71+E97+E123)) =IF(B26+B27+B28=0,0,(G45+G71+G97+G123)) =IF(B26+B27+B28=0,0,(G46+G72+G98+G124)) =IF(B26+B27+B28=0,0,(E45+E71+E97+E123)) =IF(B26+B27+B28=0,0,(G45+G71+G97+G123)) =IF(B26+B27+B28=0,0,(G46+G72+G98+G124)) =IF(B26+B27+B28=0,0,(E45+E71+E97+E123)) =IF(B26+B27+B28=0,0,(G45+G71+G97+G123)) Maybe I've looked at this to long but they look identical Marc "Peo Sjoblom" wrote in message ... So where are the statements? -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Marc" wrote in message . net... They are basically the same statement only the false statement is different but all the cells false statement formula are correct the first statement returns "0" regardless, the second the correct amount and the third "0". I have tried moving the formula to different cell and the same thing happens. Marc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| importing csv files, problem with date formats | Excel Worksheet Functions | |||
| Strange problem....excel not responding | Excel Discussion (Misc queries) | |||
| Strange Vlookup problem | Excel Worksheet Functions | |||
| Very strange problem when inserting a picture in a 3D Chart | Charts and Charting in Excel | |||
| Use SQL statements in Excel VBA to query SQL Server Data Problem | Excel Worksheet Functions | |||
Hybrid Mode
