| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#N/A
The formula show me #N/A if i dont write anything in A2 OR E2.
I want the formula to work just after i write something in A2 or E2, or in both cells. And .....can formula to show me "no day" if i write something wrong in cell A2 or E2, or if the formula doesn't find correct data in PLANNING!...? The formula to give me "yes" or "no" if everithing its ok, and "no day" if something its wrong. The formula to have "yes", "no" and "no day". This is the formula: =IF(VLOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B1;"dddd ");"YES";"NO") my table a B E PLANNING! B C 1 JOHN 02.06.2008 YES JOHN MONDAY 2 JOHN 01.06.2008 NO 3 JON 02.06.2008 no day .................................................. ..misstype 4 ...........................................nothing written And, if i dont ask too much, can the formula show "no day" in red???? Thanks in advance. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#N/A
=IF(ISNA(VLOOKUP(A1;PLANNING!B:C;2;FALSE)),"",IF(V LOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B1;"dddd");"Y ES";"NO"))
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "puiuluipui" wrote in message ... The formula show me #N/A if i dont write anything in A2 OR E2. I want the formula to work just after i write something in A2 or E2, or in both cells. And .....can formula to show me "no day" if i write something wrong in cell A2 or E2, or if the formula doesn't find correct data in PLANNING!...? The formula to give me "yes" or "no" if everithing its ok, and "no day" if something its wrong. The formula to have "yes", "no" and "no day". This is the formula: =IF(VLOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B1;"dddd ");"YES";"NO") my table a B E PLANNING! B C 1 JOHN 02.06.2008 YES JOHN MONDAY 2 JOHN 01.06.2008 NO 3 JON 02.06.2008 no day .................................................. .misstype 4 ..........................................nothing written And, if i dont ask too much, can the formula show "no day" in red???? Thanks in advance. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#N/A
Its working, but when i write something in cell A, the formula show me
"no",even i didn't write anything in B cell. I want the formula to show the result only after i write in both cells, A and B. Thanks allot. "Bob Phillips" a scris: =IF(ISNA(VLOOKUP(A1;PLANNING!B:C;2;FALSE)),"",IF(V LOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B1;"dddd");"Y ES";"NO")) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "puiuluipui" wrote in message ... The formula show me #N/A if i dont write anything in A2 OR E2. I want the formula to work just after i write something in A2 or E2, or in both cells. And .....can formula to show me "no day" if i write something wrong in cell A2 or E2, or if the formula doesn't find correct data in PLANNING!...? The formula to give me "yes" or "no" if everithing its ok, and "no day" if something its wrong. The formula to have "yes", "no" and "no day". This is the formula: =IF(VLOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B1;"dddd ");"YES";"NO") my table a B E PLANNING! B C 1 JOHN 02.06.2008 YES JOHN MONDAY 2 JOHN 01.06.2008 NO 3 JON 02.06.2008 no day .................................................. .misstype 4 ..........................................nothing written And, if i dont ask too much, can the formula show "no day" in red???? Thanks in advance. Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#N/A
=IF(OR(B1="",ISNA(VLOOKUP(A1;PLANNING!B:C;2;FALSE) )),"",IF(VLOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B1; "dddd");"YES";"NO"))
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "puiuluipui" wrote in message ... Its working, but when i write something in cell A, the formula show me "no",even i didn't write anything in B cell. I want the formula to show the result only after i write in both cells, A and B. Thanks allot. "Bob Phillips" a scris: =IF(ISNA(VLOOKUP(A1;PLANNING!B:C;2;FALSE)),"",IF(V LOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B1;"dddd");"Y ES";"NO")) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "puiuluipui" wrote in message ... The formula show me #N/A if i dont write anything in A2 OR E2. I want the formula to work just after i write something in A2 or E2, or in both cells. And .....can formula to show me "no day" if i write something wrong in cell A2 or E2, or if the formula doesn't find correct data in PLANNING!...? The formula to give me "yes" or "no" if everithing its ok, and "no day" if something its wrong. The formula to have "yes", "no" and "no day". This is the formula: =IF(VLOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B1;"dddd ");"YES";"NO") my table a B E PLANNING! B C 1 JOHN 02.06.2008 YES JOHN MONDAY 2 JOHN 01.06.2008 NO 3 JON 02.06.2008 no day .................................................. .misstype 4 ..........................................nothing written And, if i dont ask too much, can the formula show "no day" in red???? Thanks in advance. Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#N/A
its working, but if i write something, and than i delete it, the formula its
still working and display "no day". i closed excel and open it again, but... "no day its still showing. the cell are empty, but......the formula its showing "no day" =IF(OR(B1="",ISNA(VLOOKUP(A1;PLANNING!B:C;2;FALSE) )),"no day",IF(VLOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B1;" dddd");"YES";"NO")) anyway, its working. if you can help me with yhis one, i will be very glad. if not, thanks anyway you helped me allot. thanks "Bob Phillips" a scris: =IF(OR(B1="",ISNA(VLOOKUP(A1;PLANNING!B:C;2;FALSE) )),"",IF(VLOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B1; "dddd");"YES";"NO")) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "puiuluipui" wrote in message ... Its working, but when i write something in cell A, the formula show me "no",even i didn't write anything in B cell. I want the formula to show the result only after i write in both cells, A and B. Thanks allot. "Bob Phillips" a scris: =IF(ISNA(VLOOKUP(A1;PLANNING!B:C;2;FALSE)),"",IF(V LOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B1;"dddd");"Y ES";"NO")) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "puiuluipui" wrote in message ... The formula show me #N/A if i dont write anything in A2 OR E2. I want the formula to work just after i write something in A2 or E2, or in both cells. And .....can formula to show me "no day" if i write something wrong in cell A2 or E2, or if the formula doesn't find correct data in PLANNING!...? The formula to give me "yes" or "no" if everithing its ok, and "no day" if something its wrong. The formula to have "yes", "no" and "no day". This is the formula: =IF(VLOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B1;"dddd ");"YES";"NO") my table a B E PLANNING! B C 1 JOHN 02.06.2008 YES JOHN MONDAY 2 JOHN 01.06.2008 NO 3 JON 02.06.2008 no day .................................................. .misstype 4 ..........................................nothing written And, if i dont ask too much, can the formula show "no day" in red???? Thanks in advance. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
