-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
=ifc2
-
S
Implementing ISBLANK into a formula
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...- sturnusek
- Thread
- =ifc2 based date formula return
- Replies: 6
- Forum: Excel Questions
-
E
Simple IF Statement
Hi there, In cell C2 (green) I have the following basic formula =IF(C2<B2,C2,B2). I would like to add another argument that if no entry is put in cell B2, then cell A2 is returned instead of "0". Any assistance would be greatly recieved. Regards Ben <colgroup><col width="29" style="width...- EvansB2
- Thread
- =ifc2 basic formula green statement
- Replies: 10
- Forum: Excel Questions
-
M
Why is this formula returning unexpected value?
The following formula exists in cell G2 =IF(C2<1,"",IFERROR(LOOKUP(2^15,SEARCH(Table!$A$2:$A$42000,A2),Table!$A$2:$A$42000),"")) The contents of cell C2 is “2” The expected result for cell G2 is a blank cell but the formula is returning “0”- meppwc
- Thread
- =ifc2 cell exists formula returning
- Replies: 3
- Forum: Excel Questions
-
M
Display Hyperlink dependent on value
Okay so this has been picking at my brain for sometime now... Can anyone help me out with this, here is what I have so far. "=if(C2,">=1","")HYPERLINK(B2))"- Muffle
- Thread
- =ifc2 brain dependent hyperlink hyperlinkb2
- Replies: 3
- Forum: Excel Questions
