2017-12-05 11:31:49 Excel関数のお勉強 忘れる メモ
ホームページ多数作成 Excelの文字列関数こんな感じです。
あまり Excelでの作成は よくないらしいけどね。??
入力したデータから htmlに利用できるように数式
=IF(E28="〇","-ha_",IF(E28="〇","-ji_",IF(OR(E28=" ",E28="不明",E28="〇",E28="その他"),"-x_",IFERROR("-x_",AD28))))
データシートのセル番の変更で Cells(1,1)赤字が変更でき データの変更が可能になる。
= INDIRECT( "〇〇データ!AH"&$A$1 )
HTMLのタグの中にデータを入れる
= IF(A7="〇",CONCATENATE( ""),IF(OR(A5="〇〇",A5="〇"),CONCATENATE(""),CONCATENATE("")))
Excelの文字列関数こんな感じです。
= INDIRECT( "〇〇データ!AH"&$A$1 )
= IF(A7="〇",CONCATENATE( " < meta name=""keywords"" content=""〇〇〇"" > "),IF(OR(A5="〇〇",A5="〇"),CONCATENATE(" < meta name=""keywords"" content=""〇,",A4,",",A8,A7,",〇"" > "),CONCATENATE(" < meta name=""keywords"" content=""〇・〇,A4,",",A5,",",A6,",",A8,",〇"" > ")))
=IF( A7="〇",CONCATENATE(" < h3 class=""heading"" > ",A4," ",A7," < /h3 > "),IF(OR(A5="〇〇",A5="〇"),CONCATENATE(" < h3 class=""heading"" > ",A4," ",A7," ",A8," < /h3 > "),CONCATENATE(" < h3 class=""heading"" > ",A4," ",A5,"(",A6,")"," ",A7," ",A8," < /h3 > ")))
Excelの文字列関数こんな感じです。
= INDIRECT( "〇〇データ!AH"&$A$1 )
= IF(A7="〇",CONCATENATE( " < meta name=""keywords"" content=""〇〇〇"" > "),IF(OR(A5="〇〇",A5="〇"),CONCATENATE(" < meta name=""keywords"" content=""〇,",A4,",",A8,A7,",〇"" > "),CONCATENATE(" < meta name=""keywords"" content=""〇・〇,A4,",",A5,",",A6,",",A8,",〇"" > ")))
=IF( A7="〇",CONCATENATE(" < h3 class=""heading"" > ",A4," ",A7," < /h3 > "),IF(OR(A5="〇〇",A5="〇"),CONCATENATE(" < h3 class=""heading"" > ",A4," ",A7,"?",A8," < /h3 > "),CONCATENATE(" < h3 class=""heading"" > ",A4,"?",A5,"(",A6,")"," ",A7,"?",A8," < /h3 > ")))
=CONCATENATE(" < tr > < td > ",IF(A7="〇","アクセス","goo")," < /td > < td > ")
=IF(A7="〇",INDIRECT("〇!H"&$A$1),IF(A19 < > 0,IF(OR(A5="不明 不明",A5="不明 ",A5=" "),"不明",CONCATENATE(" < a target=""_blank"" href=""",A19,""" > ",A5," < /a > "))