Thread: [Solved] Need assistance with multiple IF argument formula
View Single Post
 
Old 02-25-2016, 10:05 AM
Btrrcup610 Btrrcup610 is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Feb 2016
Posts: 1
Btrrcup610 is on a distinguished road
Default 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
Reply With Quote