Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 FORMULA IN 1
Hy, i need this two formulas toghether...can it be done?
First formula show me :yes: or "no", and the second formula show me "monday", "friday"...etc I would like the formula to show me something like this: yes/monday or no/friday no/tuesday ....etc THIS FORMULA IS IN "H6" =IF(OR(E6="";ISNA(VLOOKUP(C6;PLANNING!B:C;2;FALSE) ));"";IF(VLOOKUP(C6;PLANNING!B:C;2;FALSE)=TEXT(E6; "dddd");"YES";"NO")) THIS FORMULA IS IN "J6" =IF(E6="";"";TEXT(E6;"dddd")) But i would like this combined formulas in cell "H6" thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 FORMULA IN 1
=IF(OR(E6="";ISNA(VLOOKUP(C6;PLANNING!B:C;2;FALSE) ));"";IF(VLOOKUP(C6;PLANNING!B:C;2;FALSE)=TEXT(E6; "dddd");"YES";"NO"))
&"/"&IF(E6="";"";TEXT(E6;"dddd")) -- David Biddulph "puiuluipui" wrote in message ... Hy, i need this two formulas toghether...can it be done? First formula show me :yes: or "no", and the second formula show me "monday", "friday"...etc I would like the formula to show me something like this: yes/monday or no/friday no/tuesday ...etc THIS FORMULA IS IN "H6" =IF(OR(E6="";ISNA(VLOOKUP(C6;PLANNING!B:C;2;FALSE) ));"";IF(VLOOKUP(C6;PLANNING!B:C;2;FALSE)=TEXT(E6; "dddd");"YES";"NO")) THIS FORMULA IS IN "J6" =IF(E6="";"";TEXT(E6;"dddd")) But i would like this combined formulas in cell "H6" thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 FORMULA IN 1
David,.... The formula its working,but...it show me "/" when i dont write anything... I want the formula to work after i write something. The formula to work only after i write something in "C6" or in "E6". When "C6" or "E6" its empty, i dont want "/" to appear. Thanks allot! "David Biddulph" a scris: =IF(OR(E6="";ISNA(VLOOKUP(C6;PLANNING!B:C;2;FALSE) ));"";IF(VLOOKUP(C6;PLANNING!B:C;2;FALSE)=TEXT(E6; "dddd");"YES";"NO")) &"/"&IF(E6="";"";TEXT(E6;"dddd")) -- David Biddulph "puiuluipui" wrote in message ... Hy, i need this two formulas toghether...can it be done? First formula show me :yes: or "no", and the second formula show me "monday", "friday"...etc I would like the formula to show me something like this: yes/monday or no/friday no/tuesday ...etc THIS FORMULA IS IN "H6" =IF(OR(E6="";ISNA(VLOOKUP(C6;PLANNING!B:C;2;FALSE) ));"";IF(VLOOKUP(C6;PLANNING!B:C;2;FALSE)=TEXT(E6; "dddd");"YES";"NO")) THIS FORMULA IS IN "J6" =IF(E6="";"";TEXT(E6;"dddd")) But i would like this combined formulas in cell "H6" thanks in advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 FORMULA IN 1
=IF(OR(E6="";C6="");"";IF(OR(E6="";ISNA(VLOOKUP(C6 ;PLANNING!B:C;2;FALSE)));"";IF(VLOOKUP(C6;PLANNING !B:C;2;FALSE)=TEXT(E6;"dddd");"YES";"NO"))&"/"&IF(E6="";"";TEXT(E6;"dddd")))
-- David Biddulph "puiuluipui" wrote in message ... David,.... The formula its working,but...it show me "/" when i dont write anything... I want the formula to work after i write something. The formula to work only after i write something in "C6" or in "E6". When "C6" or "E6" its empty, i dont want "/" to appear. Thanks allot! "David Biddulph" a scris: =IF(OR(E6="";ISNA(VLOOKUP(C6;PLANNING!B:C;2;FALSE) ));"";IF(VLOOKUP(C6;PLANNING!B:C;2;FALSE)=TEXT(E6; "dddd");"YES";"NO")) &"/"&IF(E6="";"";TEXT(E6;"dddd")) -- David Biddulph "puiuluipui" wrote in message ... Hy, i need this two formulas toghether...can it be done? First formula show me :yes: or "no", and the second formula show me "monday", "friday"...etc I would like the formula to show me something like this: yes/monday or no/friday no/tuesday ...etc THIS FORMULA IS IN "H6" =IF(OR(E6="";ISNA(VLOOKUP(C6;PLANNING!B:C;2;FALSE) ));"";IF(VLOOKUP(C6;PLANNING!B:C;2;FALSE)=TEXT(E6; "dddd");"YES";"NO")) THIS FORMULA IS IN "J6" =IF(E6="";"";TEXT(E6;"dddd")) But i would like this combined formulas in cell "H6" thanks in advance |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 FORMULA IN 1
Thanks! It works great!
Thanks again! "David Biddulph" a scris: =IF(OR(E6="";C6="");"";IF(OR(E6="";ISNA(VLOOKUP(C6 ;PLANNING!B:C;2;FALSE)));"";IF(VLOOKUP(C6;PLANNING !B:C;2;FALSE)=TEXT(E6;"dddd");"YES";"NO"))&"/"&IF(E6="";"";TEXT(E6;"dddd"))) -- David Biddulph "puiuluipui" wrote in message ... David,.... The formula its working,but...it show me "/" when i dont write anything... I want the formula to work after i write something. The formula to work only after i write something in "C6" or in "E6". When "C6" or "E6" its empty, i dont want "/" to appear. Thanks allot! "David Biddulph" a scris: =IF(OR(E6="";ISNA(VLOOKUP(C6;PLANNING!B:C;2;FALSE) ));"";IF(VLOOKUP(C6;PLANNING!B:C;2;FALSE)=TEXT(E6; "dddd");"YES";"NO")) &"/"&IF(E6="";"";TEXT(E6;"dddd")) -- David Biddulph "puiuluipui" wrote in message ... Hy, i need this two formulas toghether...can it be done? First formula show me :yes: or "no", and the second formula show me "monday", "friday"...etc I would like the formula to show me something like this: yes/monday or no/friday no/tuesday ...etc THIS FORMULA IS IN "H6" =IF(OR(E6="";ISNA(VLOOKUP(C6;PLANNING!B:C;2;FALSE) ));"";IF(VLOOKUP(C6;PLANNING!B:C;2;FALSE)=TEXT(E6; "dddd");"YES";"NO")) THIS FORMULA IS IN "J6" =IF(E6="";"";TEXT(E6;"dddd")) But i would like this combined formulas in cell "H6" thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|