Formula Has Too Few Arguments....

**ZooTV92** · 06-27-2011, 06:55 AM

=IF(OR(Schedule!$B7<VLOOKUP($J7,EmpInfo!$C$3:$V$200,7,FALSE)),((IF($F7="close",(MOD($AE$4-$B7,1))*24,(MOD($F7-$B7,1))*24))>=MOD(VLOOKUP($J7,EmpInfo!$C$3:$V$200,8,FALSE)-Schedule!$B7,1)*24),"",AvailabilityCheck())

Pretty sure it's a bracketing issue, but my eyes hurt from looking at it.

I'm not even sure the formula will do what I want, but I at least need to get it to work.

Wait a few moments on the reply so I don't feel like a complete idiot.

Thanks!

**romperstomper** · 06-27-2011, 07:10 AM

If I'm reading that correctly, you have 4 arguments in the first IF condition. Since the formula makes little sense to me, I can't say what it should be. Why is the OR there when you only have one test inside it?

**ZooTV92** · 06-27-2011, 07:58 AM

The two OR conditions are (or should be):

(Schedule!$B7<VLOOKUP($J7,EmpInfo!$C$3:$V$200,7,FALSE)

and

(IF($F7="close",(MOD($AE$4-$B7,1))*24,(MOD($F7-$B7,1))*24))>=MOD(VLOOKUP($J7,EmpInfo!$C$3:$V$200,8,FALSE)-Schedule!$B7,1)*24)

Depending on the true/false return, the response would be nothing ("") or to call the function AvailabilityCheck

Thanks for the response.

**romperstomper** · 06-27-2011, 08:00 AM

Then you have closed off the OR too soon - at a quick glance:

=IF(OR(Schedule!$B7<VLOOKUP($J7,EmpInfo!$C$3:$V$200,7,FALSE),((IF($F7="close",(MOD($AE$4-$B7,1))*24,(MOD($F7-$B7,1))*24))>=MOD(VLOOKUP($J7,EmpInfo!$C$3:$V$200,8,FALSE)-Schedule!$B7,1)*24)),"",AvailabilityCheck())

**ZooTV92** · 06-27-2011, 08:11 AM

That was it...thank you so much for your help!

**romperstomper** · 06-27-2011, 08:14 AM

Glad to help.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save