Download the featured file here: www.bluepecant...
------------------------------------------------------------
Blue Pecan Computer Training Ltd offers on-site or online Excel training for businesses. Training can be delivered at your business premises in the south-east of England or via Teams wherever you are in the world. Visit our training page at www.bluepecan....
In this video I demonstrate how to ignore a formula or stop calculating if a specified cell is blank or if two or more cells are blank.
In our scenario we are calculating the percentage of calls (at a call centre) that are dropped. If either the total number of calls is blank or if the number of dropped calls is blank, we don't want to perform the calculation.
There are two methods that you can use to evaluate whether a cell is blank. The first uses the ISBLANK function. This will return TRUE if the cell is empty but FALSE if it contains an empty text string.
The second method tests for an empty text string, eg =A1="". This method will return TRUE if the cell is empty or if it contains an empty text string.
You will need to decide which method works best for your scenario, but the difference between the two tests is the focus of this tutorial.
I also explain how to test more than one cell for their "emptiness" or "blankness".
------------------------
Негізгі бет How to Ignore Formula / Not Calculate If Cell is Blank in Excel
Пікірлер: 70