Need assistance with multiple IF argument formula

Btrrcup610 · #1 02-25-2016, 10:05 AM

Objective is to have formula that shows the Price (column F) of items that are 30 days overdue from Date Priced (Column E) AND do not have a CO# (Column G). This is the formula that I tried to create, but is not correct. Please help!

=IF(AND(TODAY()>(E2+30)),ISBLANK(G2),F2," ")

Data Example:

Date*Priced Price CO #
06/05/15 $32,366.00 2
12/14/15 $5,438.52

xor · #2 02-25-2016, 11:14 AM

You are really close

=IF(AND(TODAY()>(E2+30),ISBLANK(G2)),F2," ")

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need assistance to find and replace text within headers/footers in excel - multiple worksheets	teddycatnc	Excel	3	03-07-2016 12:04 AM
Assistance with Word 2010 If formula	ciresuark	Word	1	03-09-2015 12:57 PM
Array argument in macro command	Wries	Excel Programming	2	11-20-2012 01:08 AM
Command Line Argument	xJediDadx	Outlook	1	02-21-2011 03:47 PM
Formula assistance please	blazzercat	Excel	2	07-08-2009 08:45 AM