jeudi 8 mars 2018

More than one Excel If statement for analysing a time range

Im trying to input a time in C6 and get a different time in another cell

EXAMPLE::

=IF(AND(C6=TIMEVALUE("08:00:00")),TIMEVALUE("16:00:00"),IF(AND(C6=TIMEVALUE("08:00:00")),TIMEVALUE("16:00:00"),0.327,IF(C6=TIMEVALUE("08:00:00")),TIMEVALUE("16:00:00")))

Aucun commentaire:

Enregistrer un commentaire