How to use Combination of IF ISBLANK Formula in Excel | Excel Formula Hacks Advance
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
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
بـار بازدید شده