Cell blank - contains - formula - reference issues

C

Camel123

Board Regular
Joined
Jun 5, 2018
Messages
186
Hi,

In A1 I have blank containing formulas. In B1 I have in IF function a logical test checking if A1= blank then TRUE. I tried =IF(isblank(a1).... and IF(a1="")... but somehow it returns false. What to do?
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Sort by date Sort by votes
="" is an empty string not a blank

A​
B​
C​
D​
E​
F​
1​
TRUE​
0​
FALSE​
FALSE​
#N/A​
2​
FALSE​
0​
TRUE​
TRUE​
=""
3​
4​
 =ISBLANK(A1)=LEN(A1)=ISFORMULA(A1)=ISTEXT(A1)=FORMULATEXT(A1)
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Solved
Conditional format when another cell is blank (But is it??)
Replies
3
Views
224
Fluff
Fluff
L
  • Solved
Returning a date in a cell, but leave blank if no date entered
Replies
8
Views
318
Peter_SSs
Peter_SSs
C
  • Question
if " value in field name" is blank or under 100 return 0 otherwise return 1 - how do I get this formula to work
Replies
7
Views
211
Scott Huish
Scott Huish
D
  • Question
Correctly Write Formula For Time < 59 Minutes
Replies
6
Views
126
Fluff
Fluff
srizki
  • Question
Filter with blank cells
2
Replies
11
Views
178
Joe4
Joe4

Forum statistics

Threads
1,215,494
Messages
6,125,139
Members
449,207
Latest member
VictorSiwiide

Share this page

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
Back
Top