vendredi 11 novembre 2016

=IF(ISBLANK(F3);"Aanwezig") ; IF(NOT(ISBLANK(F3));"Uitgeleend") ; IF(ISBLANK(H3);"Uitgeleend") ; IF(NOT(ISBLANK(H3));"Terug")

can anyone help me with this formula?

=IF(ISBLANK(F3);"Aanwezig") ; IF(NOT(ISBLANK(F3));"Uitgeleend") ; IF(ISBLANK(H3);"Uitgeleend") ; IF(NOT(ISBLANK(H3));"Terug")

So I don't know how to explain it better... I hope its clear..

This is what is want, but it gives the #VALUE! error... Im trying to use excel as a lending system.

Anyone give me the right formula? I'm stuck:(

Thanks!

Aucun commentaire:

Enregistrer un commentaire