change isblank() to true

[ACCA369]

SAMPLE_1

VALUE_RETURN

CHECK BLANK

1​

115​

FALSE​

20​

400​

FALSE​

30​

550​

FALSE​

35​

625​

FALSE​

FALSE​

FALSE​

FALSE​

TRUE​

TRUE​

WHENEVER I ENTER DATA IN A COLUMN , IT WILL AUTOMATICALLY POPULATE VALUE IN B BASED ON FORMULA

*

FORMULA USED IN B COLUMN IS ----- IF(A1="","",(A1*15)+10)

**

FORMULA USED IN D IS TO CHECH WHETHER "B1" IS BLANK ISBLANK(B1)

***

I HAVE DRAG THE FORMULA IN B COLUMN UPTO B8 CELL

EVENTHOUGH THE B6 CELL IS BLANK WHEN I CHECK USING FORMULA ISBLANK(B6) ---> FALSE

MY QUESTION HOW TO MAKE THESE CELLS B6 TO - ISBLANK(B6)----> TRUE

without deleting the formula in b column cell

 

[Fluff]

Because col B has a formula, the cells are not blank. Try

+Fluff 1.xlsm
	A	B	C	D
1
2	1	25		FALSE
3	2	40		FALSE
4	3	55		FALSE
5				TRUE
6				TRUE
7				TRUE
8				TRUE
Data

Cell Formulas
Range	Formula
B2:B8	B2	=IF(A2="","",(A2*15)+10)
D2:D8	D2	=B2=""