formula

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
 
H

Harry Bo

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If and LOOKUP - results in multiple columns 6
Lookup Formula 4
Array Formula for numbering similar nos (counting) 1
Nested If Statement help 1
Calculate difference between current date & prior 3
Using the IF and Sheets 0
IF AND calculations with date 5
Search between dates & return other column 8

Top