How to Use Microsoft Excel Count Blank Formula
In English
Counts the empty calles in a specified range of cells.
Count Black Formula-: Ye formula pure sheet me kahi bhi cell agar khali rah jata hai to use Count blank formula dikha ta hai . Jaise ki aap niche Table me dekh sakte hai.
TABLE
Sr.No A
1 1
2 shyam
3 Raju
4 ..........
5 2
Example
Syntax: = count blank(range )Press Enter Buttom.
= Count blank(A1:A5) press Enter Buttom.
= 1
Aap ne upar ke example me dekh ki pure sheet me ek jagar par cell khali hai to formula 1 dikhaya hai. Agar sheet me ek se jayada cell khali rahata to use bhi dekhata.
Hame lag ta hai ki aap Ab samajh gaye honge agar koi canfiution ho to aap comment kar ke puchh sakate hai.
Syntax: = count blank(range )Press Enter Buttom.
= Count blank(A1:A5) press Enter Buttom.
= 1
Aap ne upar ke example me dekh ki pure sheet me ek jagar par cell khali hai to formula 1 dikhaya hai. Agar sheet me ek se jayada cell khali rahata to use bhi dekhata.
Hame lag ta hai ki aap Ab samajh gaye honge agar koi canfiution ho to aap comment kar ke puchh sakate hai.
1 Comments
Good
ReplyDelete