Too much arguments in one cell

[Blue_Wings]

Hello,

I have a cell (F10) that picks up values from cells B10 and C10 that have times, for example if cell B10 or cell C10 have 11:00 hours i recieve in cell F10 5 euros.

i have this logical function in cell F10:

=IF(AND(B10>=TIME(0;0;0);B10<=TIME(13;0;0);NOT(B10 =""));5;IF(AND(B10>TIME(13;0;0);B10<=TIME(21;0;0)) ;10;IF(AND(B10>TIME(21;0;0);B10<=TIME(23;59;59));1 5;IF(AND(C10>=TIME(0;0;0);C10<=TIME(13;0;0);NOT(C1 0=""));5;IF(AND(C10>TIME(13;0;0);C10<=TIME(20;0;0) );10;IF(AND(C10>TIME(20;0;0);C10<=TIME(23;59;59)); 15; IF(AND(NOT(B10="";C10=""));20;0)))))))

Its all working fine but excel says that i have too many arguments, its possible to shrink this ?

This last part is to when the both cells B10 and C10 have some kind of time i want the value 20 euros in cell F10.
IF(AND(NOT(B10="";C10=""));20;0)))))))

Thanks

[zbor]

See example if it's working for you:

[Blue_Wings]

See example if it's working for you:

It helps a lot but when i put 22:34 inside cell B10 for example ir doesnt put the correct number in cell F10, where do i put the function TIME() ?

Thanks

[zbor]

Yes, sorry.. No need for TIME function just divide by 24:

=IF(AND(B10="";C10="");0;IF(B10*C10>0;20;MAX(LOOKUP(MOD(B10;24);{0;13;21}/24;{5;10;15});LOOKUP(MOD(C10;24);{0;13;20}/24;{5;10;15}))))

If your results are equal you can join them into one formula but in your example B10 are fo 0:00, 13:00 and 21:00 and C10 for 0:00, 13:00 and 20:00

[Blue_Wings]

Problem solved, with this:


=IF(AND(C13>=TIME(0;0;0);C13<=TIME(23;59;59);NOT(C13="");B13>=TIME(0;0;0);B13<=TIME(23;59;59);NOT(B13=""));30;IF(AND(B13>=TIME(0;0;0);B13<=TIME(13;0;0);NOT(B13=""));65;IF(AND(B13>TIME(13;0;0);B13<=TIME(21;0;0));45;IF(AND(B13>TIME(21;0;0);B13<=TIME(23;59;59));30;IF(AND(C13>=TIME(0;0;0);C13<=TIME(13;0;0);NOT(C13=""));0;IF(AND(C13>TIME(13;0;0);C13<=TIME(20;0;0));15;IF(AND(C13>TIME(20;0;0);C13<=TIME(23;59;59));30;IF(OR(B13="x";B13="X");65;""))))))))

But i am gonna try your way, thank you.