Need assistance with multiple IF argument formula

		Microsoft Office Forums > Microsoft Excel > Excel
Need assistance with multiple IF argument formula

FAQ

Thread Tools

Display Modes

02-25-2016, 10:05 AM

Btrrcup610 Btrrcup610 is offline

Windows 7 32bit Need assistance with multiple IF argument formula

Office 2010 32bit

Novice

Join Date: Feb 2016

Posts: 1

Need assistance with multiple IF argument formula

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:49 AM.