kirimpertanyaan

 

Belajar dan konsultasi masalah Excel      

  • Home
Macro & VBA, Hits: 136, Comments: 1, Bookmarked: 0, Followers: 5

Salam kenal,

Mohon info dan pencerahan untuk membuat fungsi pada suatu teks untuk memberi syarat harus membuat email (dengan muncul kolom new email)..

 

Terima kasih

Salam,

Alvinsa

Last Modified: Monday, April 09, 2018


alvins057362
Monday, February 05, 2018
0% of 0 votes

mohon gunakan rumus "IF"

A1: OK

A2: BERMASALAH

A3: OK

 

B1: =IF(A1<>"OK","NEW EMAIL,"SOLVED")

hasil: SOLVED

B2: =IF(A2<>"OK","NEW EMAIL,"SOLVED")

hasil: NEW EMAIL

B3: =IF(A3<>"OK","NEW EMAIL,"SOLVED")

hasil: SOLVED


ardo
09 Apr 2018
0

Partners

logo baru local1news