If when blank then additional formulas

melaniemcisaac

New Member
Joined
Dec 14, 2018
Messages
3
12/10/2018
12/9/2018
=IF(A1="","",(IF(B1>A1,"NO","YES")))
NO
12/3/2018

12/2/2018

=IF(A2="","",(IF(B2>A2,"NO","YES")))
YES

<tbody>
</tbody>

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>
</tbody>
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,050
Office Version
365
Platform
Windows
In both of your examples col B is less then col A so both should say YES, which they do for me
<b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="text-align: right;;">10/12/2018</td><td style="text-align: right;;">09/12/2018</td><td style=";">YES</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="text-align: right;;">03/12/2018</td><td style="text-align: right;;">02/12/2018</td><td style=";">YES</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">sheet4</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">C1</th><td style="text-align:left">=IF(<font color="Blue">A1="","",(<font color="Red">IF(<font color="Green">B1>A1,"NO","YES"</font>)</font>)</font>)</td></tr></tbody></table></td></tr></table><br />

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

melaniemcisaac

New Member
Joined
Dec 14, 2018
Messages
3
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
ABC
110/12/201809/12/2018YES
203/12/201802/12/2018YES

<colgroup><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
sheet4

Worksheet Formulas
CellFormula
C1=IF(A1="","",(IF(B1>A1,"NO","YES")))

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>



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

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,050
Office Version
365
Platform
Windows
You're welcome
 

Forum statistics

Threads
1,081,676
Messages
5,360,441
Members
400,586
Latest member
Minty

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top