Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF command looking at a reference...
Hi, i'm trying to create an adherence report based on logged in time of an advisor on the phone. In one cell I have their logged on time which is a VLOOKUP from another sheet. I want to use this value to trigger another cell to show their scheduled logged in time
So... If cell A1 = 06:39:42 (actual logged in time lookep up from another sheet), I want cell F1 to show 07:30:00 if there is a value in A1. If 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. Neil |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF command looking at a reference...
=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 -- Brevity is the soul of wit. "neilcarden" wrote: Hi, i'm trying to create an adherence report based on logged in time of an advisor on the phone. In one cell I have their logged on time which is a VLOOKUP from another sheet. I want to use this value to trigger another cell to show their scheduled logged in time So... If cell A1 = 06:39:42 (actual logged in time lookep up from another sheet), I want cell F1 to show 07:30:00 if there is a value in A1. If 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. Neil -- neilcarden |
#3
|
|||
|
|||
Sorry, I'm not that clear at explaining... see attachment.
Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Circular reference toolbar not working | Excel Discussion (Misc queries) | |||
How to have a variable cell reference across sheets? | Excel Discussion (Misc queries) | |||
Absolute Worksheet reference number | Excel Discussion (Misc queries) |