Posts by Trish123

  • Only Show Dates between a defined start date and End Date

    Hi there,
    I have already posted this question in another forum also but to no avail but i am hoping to broaden the scope and if someone can help it would be great.
    I have a problem where i have the 4 columns consisting of an Estimated Start Date (C19) and End date(D19) and Actual Start Date(F19) and End date(G19) for different project functions.


    I am sorted for the the start of point here i have in Cell J16 =DAY(F19+1) which i have dragged all the way over the corresponding columns which only shows Monday to Friday to my estimated end date


    What I am looking for is a solution be it VBA code/Macro/a conditional formatting if this is even an option/If Statement etc.. where my Gannt Chart only shows the columns to the Actual End Date and if not the Estimated End Date??


    At the moment it ends where i ended dragging the formula across the cells.


    Any Ideas and help greatly appreciated ??

  • Excel says: You've entered too many arguments for this function:

    Re: Excel says: You've entered too many arguments for this function:


    I have done as suggested by inputting the parenthesis brackets but now i am getting an error about the formula, it works the way it is when looking at the four cells IE F15-F18 but when I add the (F19)>$D$19) part it comes up with the too many argument error. Any other ideas out there as to what I'm doing incorrect :(

  • Excel says: You've entered too many arguments for this function:

    Re: Excel says: You've entered too many arguments for this function:


    Quote from S O;781324

    =IF(F20="","",IF(AND((F15)>=$D$15,(F16)>=$D$16,(F17)>=$D$17,(F18)>$D$18),(F19)>$D$19)),RANK(F20,$E$20:$AE$20),"FAIL"))


    I think your parentheses are just in the wrong place


    :)


    That is giving me and error now with problem with this formula, any other ideas

  • IF Rank Statement

    I am trying to rank only if O17 = PASS otherwise i want it to fail,


    the following it my attempt and i cant seem to get it working


    IF( O17= "PASS", (RANK(P17,$P$17:$P$27),"FAIL"))


    Any Ideas??

  • Microsoft Word and VB

    I have developed a drop down menu on my form consisting of 13 names, but what i am looking to do is based on the first six names i want a particular table shown based on the first six names and another table shown based on the other six, but if the 13th name is chosen to show both tables, and nothing to be shown unless an option is chosen.
    can this be done?

  • Rank if and statement

    Re: Rank if and statement


    ive expanded on the initial table i was working on ans also the query as follows


    =IF(F18="","",IF(AND((F12+F13+F14)>=$D$13,(F15+F16)>=$D$16,F17>=$D$17),RANK(E19,$E$19:$AT$19),"FAIL"))


    At the moment when the conditions are met the above query is not ranking form me it just seems to be not working correctly it doesn't even seem to be ranking correctly, i have attached the updated book, its probably something i did incorrect and mixed it up.


    forum.ozgrid.com/index.php?attachment/68773/

  • Rank if and statement

    Re: Rank if and statement


    Quote from MrRedli;768333

    hope this is what you wanted:


    =IF(D9="","",IF(AND((D3+D4+D5)>=B4,(D6+D7)>B7,D8>=B8),RANK(D9,$D$9:$F$9),"FAIL"))


    MrRedli


    This is somewhat of what i am looking for, but the above statement doesnt seem to be ranking 1-5 if it meets the conditions -
    D3+D4+D5)>=B4,(D6+D7)>B7,D8>=B8)


    what is happening is its just putting in FAIL into all where there should be a rank number even when it meet the condition.


    Only if it meets the condition do i want to rant 1-5 if not i want the FAIL.

  • Rank if and statement

    The following is a formula i am using,


    =IF(D9="","",RANK(D9,$D$9:$F$9))


    this Ranking formula is working for me fine but what i am trying to do is if is possible to have an if, and, formula then rank.
    so in words it would only Rank IF =(D$3+D$4+D$5)>=$B$4 AND =(D$6+D$7)>$B$7 AND =D$8>=$B$8 otherwise FAIL and then to copy this over the other ranking cells to also incorporate the IF(D9="","") part as i will have empty cells within the rank selection.


    I have attached also my book for reference.

  • Rank every second cell

    I have a table that has a total (SUM) along the bottom at every second cell,


    What i would like to do would be to rank them 1-10


    but at the moment it looks like


    [TABLE="width: 592"]

    [tr]


    [TD="class: xl67, width: 134"]Ranking [/TD]
    [TD="class: xl68, width: 98"]2[/TD]
    [TD="class: xl68, width: 90"]#N/A[/TD]
    [TD="class: xl68, width: 94"]1[/TD]
    [TD="class: xl68, width: 84"]#N/A[/TD]
    [TD="class: xl68, width: 92"]#N/A[/TD]

    [/tr]


    [/TABLE]

  • Table in a user form, but i want the user to enter a number into all cells

    [TABLE="width: 500"]

    [tr]


    [td]

    ITEM

    [/td]


    [td]

    Price(Please enter Price)

    [/td]


    [/tr]


    [tr]


    [td]

    Windows

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    Doors

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    Brush

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [TD="align: center"]TOTAL[/TD]

    [td][/td]


    [/tr]


    [/TABLE]


    Given the above table, i am looking for a way for the Total to sum given the inputted information above the price, but if one of the cells is left blank i want a message to appear "Please enter relevant information into ALL cells".


    Any Ideas, is this even possible. i was trying something along the lines of conditional formatting but have yet to get it working correctly.

  • Conditional Formatting

    This will probable be simple for someone in the know, but what i am trying to do is if three values (F1 +F2 + F3 )added together are less than a number in another cell D3, i wish to use conditional formatting to highlight the 3 cell (F1-F3)