Three (or more) arguments/one cell

[LizzieW71]

I want t enter three arguments into one cell:
1. Calculate total days overdue
2. Mark "Received" if date in received column
3. Leave blank if not overdue

So far, I have =IF(G3>1,"RECEIVED",DAYS360(F3,TODAY())) and I get arguments 1 and 2, but I can't figure out how to add argument 3. I've tried the following but they all fail:

=IF(G3>1,"RECEIVED",DAYS360(F3,TODAY())<1,””,DAYS360(F3,TODAY()))

=IF(G3>1,"RECEIVED"),IF(F3,TODAY())<1,””,DAYS360(F3,TODAY()))

Any help would be greatly appreciated.

Liz

 

[philaugust2004]

I am assuming F3 is due date?
What does G3 represent?

 

[FranzV]

You seem to be in the right track. If you are looking for these results:

Excel 2016 (Windows) 64 bit

	F	G	H
DueDate​	Received​	Status​
2017 - feb - 28​		3​
2017 - mar - 01​	2017 - mar - 02​	Received​
2017 - mar - 02​		1​
2017 - mar - 03​	2017 - mar - 02​	Received​
2017 - mar - 04​

<tbody>
[TD="bgcolor: #888888"]

2​

[/TD]

[TD="bgcolor: #888888"]

3​

[/TD]

[TD="bgcolor: #888888"]

4​

[/TD]

[TD="bgcolor: #888888"]

5​

[/TD]

[TD="bgcolor: #888888"]

6​

[/TD]

[TD="bgcolor: #888888"]

7​

[/TD]

</tbody>

[TABLE="width: 85%"]
<tbody>[TR]
[TD]
The following formula in column H will do:

[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]H3[/TH]
[TD]=IF( G3 > 0, "Received", IF( F3 >= TODAY(), "", TODAY() - F3 ) )[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

The IF() function accepts 3 arguments; the logical condition, the result if TRUE and the result if FALSE. In your case you want to test 2 logical conditions and return 3 different results, forcing you to nest one IF() inside another. This is very common and you usually test the condition that can override any other condition first, eg. if the received date has been entered you don't care if it was received early, just in time or late, you just want to know its there. If this condition is not met, you go into a seconf IF() function placed as the result if FALSE argument of the first IF().

I think my explanation in not very clear, but I hope it helps.

*Note: If you are using Excel 2016 with an Office 365 subscription, you can use the new IFS() function.

 

[Special-K99]

IF conditions contain 3 paramaters:
a condition
a result if TRUE
a result if FALSE

=IF(G3>1,"RECEIVED",DAYS360(F3,TODAY())<1,””,DAYS360(F3,TODAY()))
This contains 5 parameters

=IF(G3>1,"RECEIVED"),IF(F3,TODAY())<1,””,DAYS360(F3,TODAY()))
This second one's a complete mess. There is no FALSE value IF G3 is not > 1, the second IF is saying F3=TRUE else IF TODAY()<1 is TRUE

You should explain in words what you're trying to achieve covering all possibliities and leave the IFs to whoever will reply.

 

[LizzieW71]

I am assuming F3 is due date?
What does G3 represent?

G3representsdatereceived.

 

[philaugust2004]

Try this.
=IF(G3>1,"RECEIVED",IF(DAYS360(F3,TODAY())<0,"",DAYS360(F3,TODAY())))

 

[LizzieW71]

Try this.
=IF(G3>1,"RECEIVED",IF(DAYS360(F3,TODAY())<0,"",DAYS360(F3,TODAY())))[/QUO

Thank you all! Those worked. I have updated my spreadsheet with the right formula. These help me keep track and monitor trends.
I have a question about conditional formatting now:
Within this same spreadsheet, I have a “Status” Column with two conditions.
1. Today’s date minus due date
2. Red/Yellow/Green stop lights to indicate how close to being due or being overdue.

I want the formula to stop counting once I receive the item and, maybe, turn the icon back to green.
There is also a 4-icon set that maybe I need to use to indicate a 4^th status for received. Any suggestions?