returning a value in a cell if condition is met

  • Thread starter Thread starter v1rt8
  • Start date Start date
V

v1rt8

H4 contains D or N
K4 contains time 00:45
V4 would return value of K4 if H4 = D,otherwise 00:00
Y4 would return value of K4 if H4 = N, otherwise 00:00

have been looking through all the questions and cant find, would greatly
appreciate
thanks
 
I have just figured it out, for anyone looking I will post the formula,
=IF(H5="N",SUM(K5)," 00:00")
 
Try this.

In cell V4 Paste this formula:-
=IF(H4="D",K4,"00:00")

In cell Y4 Paste this formula:-
=IF(H4="N",K4,"00:00")

Format the K4 value as Text and type 00:45

If this post helps, click yes!
 
Thanks for your help, one note, the value in K4 is automated by another cell
and has to be time, not text, however i will try it anyway. thanks again
 
Back
Top