Home » Forums » Open Source Learning Center » Question and Answer

Help Modifying an Existing Excel Formula

Submitted by znxm0i on 27 May, 2014 - 15:46

I would appreciate it greatly if anyone could help me figure out how to do the following:

I have a spreadsheet wherein I track the return dates of projects which are identified as "past due" depending the following formula:

=IF(TODAY()However, I want to also add to the above formula that if column Q contains the wording "FINAL" then the word "Final" should replace the word "Past Due"

I am not an Excel guru, so I am having a very hard time trying to understand how to modify the above foruma to simply add one more "if" statement

Can anyone help PLEASE.....

‹ macro code Excel 2010, how to use formulas from other, dedicated worksheet ? ›
»

Your formula is missing, but

Submitted by chris on 29 May, 2014 - 17:23.

Your formula is missing, but you want something along the lines of:

=IF(AND(TODAY()[A1,NOT(ISERROR(FIND("FINAL",Q1))),blah,blah)

Change the [ to a less-than sign. Those appear to get stripped out by the forum software, which is probably why your formula went missing too. :)

»