98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses in - 2 arguments in Excel formulas
microsoft excel courses in - 2 arguments in Excel formulas
Resolved · Low Priority · Version Standard
Mon 12 Feb 2007, 16:49Delegate Lisa said...
Lisa has attended:
Excel Intermediate course
2 arguments in Excel formulas
Can two arguments be entered in a formula? e.g.
=IF(D4>(C4+14),D4<(C4+14)"OVERDUE"," ")
I would like the formula to say overdue if it is over 14 days and nothing has been entered and not to say anything if a date is entered 14 days after the first date......can you help ;-)
Wed 14 Feb 2007, 12:04Trainer Tracy said...
RE: Formulas
Hi Lisa,
The IF function you are giving as an example doesn't work when you put in other arguments after operator. It is more straightforward, if this is true, for example, A1+B1=3 then........., if it is not true then............
What I suggest is =IF(B1-A1>14, "Overdue","") this will compare the dates and if it is more that 14 days old it will come out as overdue. So you can put in a formula but it must be before the operator.
Good luck
Tracy
Microsoft Excel training course instructor.
Wed 14 Feb 2007, 12:43Delegate Lisa said...
RE: Formulas
Hello Tracey,
The formula you give me is doing the same thing as the one I am currently using the problem I am having is that I want to incoperate into that formula another argument which will look at the current date and if it is 14 days and nothing has been entered in B1 then say overdue what is happending now it that formula is causeing things that is entered today to say overdue when it has not been sent as yet.......sorry :-)
lisa
Fri 23 Feb 2007, 16:19Trainer Tracy said...
RE: Formulas
Hi Lisa,
Sorry for the delay, here are a couple of things you could try. There is a function called =TODAY() which returns todays date each time you open excel. There is another function called DAYS360(C4,D4) where the result will be the amount of days between the date in C4 and the date in D4. Try that and perhaps use the if function on the result.
Let me know how you get on
Tracy
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Removing custom dictionary entriesIf you add something to the custom dictionary in Excel you cannot remove it. The way to get around this is to go into word and remove it there. |
