IF command looking at a reference...

N

neilcarden

Hi, i'm trying to create an adherence report based on logged in time o
an advisor on the phone. In one cell I have their logged on time whic
is a VLOOKUP from another sheet. I want to use this value to trigge
another cell to show their scheduled logged in time

So...

If cell A1 = 06:39:42 (actual logged in time lookep up from anothe
sheet), I want cell F1 to show 07:30:00 if there is a value in A1. I
A1 is blank, i want F1 to show blank...

I've tried with IF but I think the VLOOKUP is fudging it..

Thanks in advance.
Nei
 
D

Dave F

=IF(ISBLANK(A1),"",07:30:00)

I'm not clear from your post what's in A1. Is either 06:38:42 OR blank? If
that's the case then the formula above should work. If there are more
alternatives besides 06:38:42, then do you also want 07:30:00 to appear?

Dave
 
Top