NEED FORMULA HELP
 

I AM TRYING TO WRITE A FORMULA THAT WILL RETURN ONE OF THREE RESULTS. I HAVE
TRIED ALL DIFFERENT WAYS TO WRITE IT, BUT HAVE COME UP SHORT AND VERY
FRUSTRATED...

I WANT THE FOLLOWING TO HAPPEN IN CELL N177:
1. IF CELL(I177) IS BLANK, I WANT IT TO CALCULATE THE DIFFERENCE BETWEEN
TODAY AND THE DATE ENTERED IN CELL F177 PLUS 6(DAYS).
2. IF TODAY IS GREATER THAN OR EQUAL TO THE DIFFERENCE BETWEEN TODAY AND THE
DATE ENTERED IN CELL F177 PLUS 6(DAYS) THEN CELL N177 SHOULD READ AS
"SUBMITTED".

I HAVE BEEN SUCESSFUL AT WRITING THIS PART...AND IT READS AS FOLLOWS
=IF(ISBLANK(I177),(NETWORKDAYS(TODAY(),F177,$D$13: $D$106)+6),IF(TODAY()=NETWORKDAYS(TODAY(),F177,$D $13:$D$106)+6,"submitted")

I GET INTO TROUBLE WHEN I TRY TO ADD THE THIRD COMPONENT:
3. I WANT TO LIMIT THE NUMBER THAT N177 SHOWS TO A MAXIMUM OF "5" (DAYS)
(I.E., IF THE DIFFERENCE BETWEEN TODAY AND THE DATE ENTERED IN CELL F177 PLUS
6(DAYS) IS GREATER THAN OR EQUAL TO 5(DAYS), IT SHOULD READ AS "5"(DAYS).

THIS FORMULA COMPUTES THE ANSWER TO NUMBER 3:
IF(NETWORKDAYS(TODAY(),F177,$D$13:$D$106)+6=5,"5" )

I CANNOT FIGURE OUT HOW TO STRING THESE ALL TOGETHER AND STILL GET THE
RESULTS I DESIRE.

PLEASE HELP!
THANK YOU IN ADVANCE FOR YOUR HELP!

NEED FORMULA HELP
 

If I understand your query correctly. You have N177 returning either a value
or the word "submitted", depending on the result of the calculation. The
number you want in N177 should be 5 or less as computed by the secodnm
formula. If so then you need to add the second formula as the 'false' value
in the first equation rather than "submitted", and add "submitted" after "5"
with a comma separating the two.

Hope this helps

Regards

David Coates

"FBNJ" wrote:

I AM TRYING TO WRITE A FORMULA THAT WILL RETURN ONE OF THREE RESULTS. I HAVE
TRIED ALL DIFFERENT WAYS TO WRITE IT, BUT HAVE COME UP SHORT AND VERY
FRUSTRATED...

I WANT THE FOLLOWING TO HAPPEN IN CELL N177:
1. IF CELL(I177) IS BLANK, I WANT IT TO CALCULATE THE DIFFERENCE BETWEEN
TODAY AND THE DATE ENTERED IN CELL F177 PLUS 6(DAYS).
2. IF TODAY IS GREATER THAN OR EQUAL TO THE DIFFERENCE BETWEEN TODAY AND THE
DATE ENTERED IN CELL F177 PLUS 6(DAYS) THEN CELL N177 SHOULD READ AS
"SUBMITTED".

I HAVE BEEN SUCESSFUL AT WRITING THIS PART...AND IT READS AS FOLLOWS:
=IF(ISBLANK(I177),(NETWORKDAYS(TODAY(),F177,$D$13: $D$106)+6),IF(TODAY()=NETWORKDAYS(TODAY(),F177,$D $13:$D$106)+6,"submitted")

I GET INTO TROUBLE WHEN I TRY TO ADD THE THIRD COMPONENT:
3. I WANT TO LIMIT THE NUMBER THAT N177 SHOWS TO A MAXIMUM OF "5" (DAYS)
(I.E., IF THE DIFFERENCE BETWEEN TODAY AND THE DATE ENTERED IN CELL F177 PLUS
6(DAYS) IS GREATER THAN OR EQUAL TO 5(DAYS), IT SHOULD READ AS "5"(DAYS).

THIS FORMULA COMPUTES THE ANSWER TO NUMBER 3:
IF(NETWORKDAYS(TODAY(),F177,$D$13:$D$106)+6=5,"5" )

I CANNOT FIGURE OUT HOW TO STRING THESE ALL TOGETHER AND STILL GET THE
RESULTS I DESIRE.

PLEASE HELP!
THANK YOU IN ADVANCE FOR YOUR HELP!