" Life is not a problem to be solved but a reality to be experienced! "
© Copyright 2013 - 2024 KUDO.TIPS - All rights reserved.
=IF(Logical_test;value_if_true;value_if_false)
kalau contohnya kurang lebih seperti ini
=IF(C7=2011(VLOOKUP(B7;$H$7:$J$11;3));VLOOKUP(B7;$H$15:$J$19;3))