# Comparing Values in Excel

#### daisyoso

##### New Member
Hi All,

I need help for the below:

A1 A2 A3
0 0 display "blank"
17-Nov-17 0 display "waiting"
17-Nov-17 16-Nov-17 display "done"

Thank you!

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

#### Zunit

##### New Member
Hi

Not sure what you mean exactly. If you want the the value in A3 to change based on the value in A1 and A2 then the below woudl work:

=IF(AND(A1=0,A2=0),"",IF(AND(A1=43056,A2=0),"Waiting",IF(AND(A1=43056,A2=43055),"Done","N/A")))

#### daisyoso

##### New Member
Thank you for the reply Zunit....just want to ask what are these 43056,43056 and 43055? Does all dates have this equivalent value?

A1 B1 C1

0 0 display "Blank"
any date 0 display "waiting"
any date any date display "N/A"

for the third, I just want that If i key in any dates in A1 and B1, it will display "N/A"

Thank you

Last edited:

#### Zunit

##### New Member
Yes excel sees dates as numbers.

#### daisyoso

##### New Member

What if i will input any dates in A1 and B1?

#### Zunit

##### New Member
You can just change the date figures to >0

#### daisyoso

##### New Member
thank you so much!

Replies
1
Views
172
Replies
7
Views
65
Replies
10
Views
150
Replies
5
Views
58
Replies
8
Views
119

1,126,998
Messages
5,622,097
Members
415,876
Latest member
csibonga2k17

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back