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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
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
178
Fluff
Fluff
L
  • Solved
Returning a date in a cell, but leave blank if no date entered
Replies
8
Views
231
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
174
Scott Huish
Scott Huish
D
  • Question
Correctly Write Formula For Time < 59 Minutes
Replies
6
Views
106
Fluff
Fluff
W
  • Solved
Conditional formatting - formula for blank or specific text
Replies
3
Views
296
Joe4
Joe4

Forum statistics

Threads
1,215,022
Messages
6,122,716
Members
449,093
Latest member
Mnur

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