=IF((ISERROR(yourformula));"";(yourformula))
- ganti titik koma dengan koma (sesuaikan dengan pengaturan excel anda)
Sumber:
https://www.mrexcel.com/board/threads/how-do-i-get-a-blank-instead-of-value.333766/
2024/08/27
menghilangkan #VALUE! pada rumus excel
Posted by Kak Irudini on 2024/08/27 10:40 AM in
Title: menghilangkan #VALUE! pada rumus excel
Link: https://karudi.blogspot.com/2024/08/menghilangkan-value-pada-rumus-excel.html
Hashtag :
IMAM RUDINI
(Rudi)
Tax and Accounting
"do u have a job for me? please hire me"