|
|
#1
08-31-2018, 02:22 AM
|
|||
|
|||
Making blank cells
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?
|
| Tags |
| microsoft excel training |
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode