Comparing Values in Excel

daisyoso

New Member
Joined
Aug 10, 2017
Messages
14
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!
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Zunit

New Member
Joined
Feb 14, 2013
Messages
32
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
Joined
Aug 10, 2017
Messages
14
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:

daisyoso

New Member
Joined
Aug 10, 2017
Messages
14

ADVERTISEMENT

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

Watch MrExcel Video

Forum statistics

Threads
1,127,161
Messages
5,623,096
Members
415,953
Latest member
Balloonman4343

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top