Implementing ISBLANK into a formula

[sturnusek]

Hello,


I am pretty new to excel and I came across a problem. I have a formula based on the date to return me a value, please see below.


=IF(C2<DATE(2018,2,29),"Not moving","Fast moving")


On some of my data, I have empty columns which I want to get identified and given a special name. I tried to do something as below, but it either gives me a Value or REF error.


IF(C2<DATE(2018,2,29),"Not moving","Fast moving"),IF(ISBLANK(C2),”Not moving”)


Any ideas how to implement it?


Thanks

 

[richardtims]

Can you please post the entire formula? Also, are you trying to return a value based on a date range or a value if it is blank? We just need more details.

 

[sturnusek]

First

=IF(C2<DATE(2018,2,29),"Not moving","Fast moving")

Second

IF(C2<DATE(2018,2,29),"Not moving","Fast moving"),IF(ISBLANK(C2),”Not moving”)

 

[Joe4]

Your formulas are not showing up.
If you have < or > signs in your formula, surround them by spaces on either side.
Those signs are mistaken for HTML code, which it tries to render, and then the formulas get cut off.
So write it like this:

=IF(C2 < 4,...

 

[sturnusek]

Thanks, I was wondering what that was...

Old

=IF(C2 < DATE(2018,2,29),"Not moving","Fast moving")

New

IF(C2 < DATE(2018,2,29),"Not moving","Fast moving"),IF(ISBLANK(C2),”Not moving”)

 

[richardtims]

<DATE(2018,2,29),"NOT moving?,?Fast html moving?))<>=IF(C2="","Not Moving",IF(C2 < DATE(2018,2,29),"Not moving","Fast moving"))

 

[sturnusek]

Worked, thank you very much!