How to use Combination of IF ISBLANK Formula in Excel | Excel Formula Hacks Advance

Excel Tutor
Excel Tutor
380 بار بازدید - 12 ماه پیش - In this video tutorial by
In this video tutorial by Excel Tutor, the #ISBLANK #function in #Excel is explained. It is a logical function that returns "true" if a cell is blank and "false" if it's not. An example is given where #ISBLANK is used to identify blank cells in a list of inventory items. In the second part of the video, the practical application of the ISBLANK function is demonstrated. The presenter uses it in #combination with the #IF #function to calculate the value of items based on whether the quantity column is filled or not. If the quantity column is blank, nothing is displayed; if it's not blank, the value is calculated by multiplying quantity with price.

Flow of the Video

00:00 Introduction to the Video
00:18 What is ISBLANK Function
00:35 ISBLANK Function - Example
01:16 Practical Application of ISBLANK Function
01:49 Use ISBLANK Function along with IF Function
02:50 Closing the Video
12 ماه پیش در تاریخ 1402/08/06 منتشر شده است.
380 بـار بازدید شده
... بیشتر