I am trying to use this formula to trigger events based on a seconds timer, everything seams to work except the part for the timer in the LOOKUP formula it just skips over it like it is false.
=IF(F11="","",IF($D$9=4,IF(Data!T5<>"",IF(H5="",LOOKUP(B6,{30,32,35,45,47,50},{"LAY1","CLEAR","CANCEL","LAY2","CLEAR","CANCEL"}),"LAY3"),"LAY4"),""))
Formula help
Moderator: 2020vision
2 posts
• Page 1 of 1
Formula help
by Shaun » Fri Jul 25, 2008 2:35 pm
- Shaun
- Posts: 435
- Joined: Fri May 09, 2008 11:11 pm
- Location: Kellerberrin, Western Australia
by Shaun » Fri Jul 25, 2008 2:39 pm
I couldn't find the edit button, i think i fixed it i was referencing the wrong cell
=IF(F11="","",IF($D$9=4,IF(Data!T5<>"",IF(H11="",LOOKUP(B6,{30,32,35,45,47,50},{"LAY1","CLEAR","CANCEL","LAY2","CLEAR","CANCEL"}),"LAY3"),"LAY4"),""))
The error is in red
=IF(F11="","",IF($D$9=4,IF(Data!T5<>"",IF(H11="",LOOKUP(B6,{30,32,35,45,47,50},{"LAY1","CLEAR","CANCEL","LAY2","CLEAR","CANCEL"}),"LAY3"),"LAY4"),""))
The error is in red
- Shaun
- Posts: 435
- Joined: Fri May 09, 2008 11:11 pm
- Location: Kellerberrin, Western Australia
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: Google [Bot] and 48 guests