請教EXCEL FORMULA 寫法謝謝

handsome_guy

2023-5-18 15:04

如果A1開頭是ABC, B1自動填寫135

如果A4開頭是XYZ, B1自動填寫246

THANK YOU

Quiorra

如果A1開頭是ABC, B1自動填寫135

如果A4開頭是XYZ, B1自動填寫246

THANK YOU ...
handsome_guy 發表於 2023-5-18 15:05

=IF(LEFT(A1,3)="ABC","123",IF(LEFT(A1,3)="XYZ","246",""))

首先做個IF loop, 如果cell A1 左面3個字=ABC 就出123, 如果唔係就再一個IF loop, if XYZ then 246

handsome_guy

very good...thank you very much