Hide contents in cells showing "FALSE"

[Ozhatch]

I've posted a spreadsheet to my Box cloud storage:

https://app.box.com/s/g0218jyf2nd9z8byp6vhbw6vna939i54

Can someone please tell me how to write code in such a way as to show any cells show "FALSE", the cell actually appears blank?

Thanks very much.

David.

 

[RasGhul]

Hi David,


Can you provide a small sample of data into the forum as most posters get a bit nervous clicking links.

Normally you can use =IF(logical_test,[value if true],[value if false]) so when your column has False results you could use eg =IF(A=B,B,"")

 

[RasGhul]

	B	C	D	E	F	G	H	I	J	K	L	M
3	Date	Invoice Number	Primary Product	Invoice Total Before Discount	Gross Primary Product Value	Nett Invoice Total	Discount Amount	Discount Percentage	Bonus Applicable	Gross Bonus Amount	Share bonus with Closer:	Bonus Amount Each
4	16 Jul 18	1324		$ 3,350.00	$ 2,699.00	$ 3,150.00	$ 200.00	7%	Yes	$ 107.96	Amanda	$ 53.98
5	16 Jul 18	1325		$ 4,250.00	$ 3,999.00	$ 4,250.00	$ -	0%	Yes	$ 159.96
6		1326		$ 4,250.00	$ 4,250.00	$ 3,800.00	$ 450.00	11%	No
7		1327		$ 2,999.00	$ 2,799.00	$ 2,700.00	$ 99.00	4%	Yes	$ 111.96
8											Bruce

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula I4 =IF(H4="","", H4/F4) J4 =IF(I4="","",IF(I4<=9.999999%,"Yes","No")) K4 =IF(C4="","",IF(I4>10.01%,"",F4*4%)) M4 =IFERROR(IF(L4="","",(K4/2)),"") <tbody> </tbody>

<tbody>
</tbody>

 

[Ozhatch]

Thanks RasGhul; I'll keep that in mind for future posts.

 

[Ozhatch]

That makes perfect sense! Thanks again!

 

[Ozhatch]

Solved.

 

[RasGhul]

Glad you got it working