formula

  • Thread starter Thread starter amey
  • Start date Start date
A

amey

i have two cols & i need to put a formula into a 3rd 1 to displa
certain outcomes.

Col 1 col 2 col 3

date date Default
date not claimed OS
Date >2days not claimed overdue

when the things in col 1 & 2 are entered i want the things in col 3 t
b displayed. Can anyone help.

col 2 will either have a date in it or say not claimed.

todays date is in cell H1 and changed automatically everyday,usin
=TODAY() formula
 
Sorry Amey,

Forgot about the > 2days, so try this:
=IF(AND(A1=$H$1,B1=$H$1),"Default",IF(AND(A1=$H$1,B1="Not Claimed"),"OS",IF(AND(A1>$H$1+2,B1="Not Claimed"),"Overdue","")))
 
Back
Top