Thread: returning a value in a cell if condition is met
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
v1rt8 v1rt8 is offline
external usenet poster
  
Posts: 34
Default returning a value in a cell if condition is met
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
Reply With QuoteReply With Quote