Making blank cells

aysherryan · #1 08-31-2018, 02:22 AM

I have a formula in a cell. The formula includes another cell and a number. For example "=B3*(A1/100)-1". The cell containing the formula shows a number even when B3 and A1 have no values in it. Is there a way to make it show blank until a value is entered into those two cells?

p45cal · #2 08-31-2018, 03:31 AM

A pain but something like:
=IF(COUNT(A1,B3)=2,B3*(A1/100)-1,"")

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Select all cells in a column , even when blank...	Chayes	Excel Programming	4	05-30-2018 10:35 AM
Formula for blank cells	datadummy	Excel	2	09-11-2017 10:19 PM
Sorting with blank cells	mummy	Excel	1	09-02-2017 06:04 AM
Join cells together separated by ; when some are blank	leemoreau	Excel	3	11-03-2013 11:22 AM
Selecting blank cells in criteria	apolloman	Excel	6	08-24-2011 05:38 AM