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," ")

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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