If when blank then additional formulas

[melaniemcisaac]

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]12/10/2018
[/TD]
[TD]12/9/2018
[/TD]
[TD]=IF(A1="","",(IF(B1>A1,"NO","YES")))
[/TD]
[TD]NO
[/TD]
[/TR]
[TR]
[TD]12/3/2018

[/TD]
[TD]12/2/2018

[/TD]
[TD]=IF(A2="","",(IF(B2>A2,"NO","YES")))
[/TD]
[TD]YES
[/TD]
[/TR]
</tbody>[/TABLE]

I am currently trying to make these two cells both say "NO".

I cannot find where the formula stops working.

This is the formula now. =IF(A1="","",(IF(B1>A1,"NO","YES")))

The cells have the same parameters so I am not sure if it is because of the number format.

If Cell B1 is lower than A1, I want it to say "YES". If it is higher I want it to say "NO"

<tbody>
[TD="width: 36%"]

[/TD]
[TD="width: 37%"]

[/TD]
[TD="width: 27%, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffcc]#ccffcc[/URL] "]

[/TD]

[TD="width: 36%"]

[/TD]
[TD="width: 37%"]

[/TD]
[TD="width: 27%, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ccffcc]#ccffcc[/URL] "]

[/TD]

</tbody>

 

[Fluff]

In both of your examples col B is less then col A so both should say YES, which they do for me

Excel 2013/2016
	A	B	C
1	10/12/2018	09/12/2018	YES
2	03/12/2018	02/12/2018	YES
sheet4

Cell Formulas
Range	Formula
C1	=IF(A1="","",(IF(B1>A1,"NO","YES")))

Are you sure all your dates are proper dates rather than text

 

[melaniemcisaac]

Oh yes, the text.. Thank you so much for your help.

In both of your examples col B is less then col A so both should say YES, which they do for me
Excel 2013/2016

	A	B	C
YES
YES

<colgroup><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]10/12/2018[/TD]
[TD="align: right"]09/12/2018[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]03/12/2018[/TD]
[TD="align: right"]02/12/2018[/TD]

</tbody>

sheet4​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C1[/TH]
[TD="align: left"]=IF(A1="","",(IF(B1>A1,"NO","YES")))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



Are you sure all your dates are proper dates rather than text

 

[Fluff]

You're welcome