# Posts by Trish123

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 ??

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 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

Excel says: You've entered too many arguments for this function:
=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 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??

Re: Microsoft Word and VB

no it is not schoolwork, and if you dont want to help and suggest advice thats fine.

Re: Rank if and statement

MrRedi,

Thank you this is working perfectly, and i see what i was doing incorrectly in the Rank. :thanx:

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?

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/

## Files

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.

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.

## Files

Re: Rank every second cell

Thanks for that NBVC your a star :lol:

Re: Rank every second cell

[ATTACH=CONFIG]68537[/ATTACH]

Please find attached an excerpt of my excel sheet, in it i have an area where the user of the form would enter the percentage and this then totals in the cell next to it, i then want the total column ranked based on score.

## Images

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]

Re: Table in a user form, but i want the user to enter a number into all cells Works a treat,

Thanking you LukeM

Re: Conditional Formatting

Thanks Grimes0332, you come to my rescue every time , works a treat.

[TABLE="width: 500"]

[tr]

[td]

ITEM

[/td]

[td]

[/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.

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)