Cara menjumlahkan hasil rumus if
35 views
Skip to first unread message
Enti Supriya Tuti
Dec 21, 2023, 6:40:59 AM12/21/23
to Milis Belajar-Excel
Selamat sore
Mohon pencerahan
Jika sel D4 berisi rumus dari if yang nilainya 1000, lalu di Sel d5 2000 bagaimanakah rumus untuk menjumlah angka yg berasal dari rumus if
odong nando
Dec 21, 2023, 7:37:53 AM12/21/23
to Milis Belajar-Excel, Enti Supriya Tuti
hai enti
tinggal ketik
=D4 + D5
tp jika hasil dari if tersebut terbaca text oleh excel maka formulanya menjadi
tp jika hasil dari if tersebut terbaca text oleh excel maka formulanya menjadi
=INT(D4) + INT(D5)
terimakasih,
odong nando
--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to milis-belajar-e...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/93343014.2283131.1703149557349%40mail.yahoo.com.
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to milis-belajar-e...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/93343014.2283131.1703149557349%40mail.yahoo.com.
Reply all
Reply to author
Forward
0 new messages