Results 1 to 5 of 5

Too much arguments in one cell

Threaded View

  1. #1
    Registered User
    Join Date
    03-20-2010
    Location
    Portugal
    MS-Off Ver
    Excel 2019
    Posts
    69

    Unhappy Too much arguments in one cell

    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
    Last edited by Blue_Wings; 03-24-2010 at 05:35 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1