Quote:
Please someone help to solve it. If there is any wrong in the formula so please guide me proper function to solve.
Learn to use Excel integrated helping tools.
Ribbon 'Formula' > 'Formula Audit' Block > 'Formula Evaluate' : this tool will show you how Excel avalate the formula step by step, it helps you to understand where the formula goes wrong. Great learning tool.
Quote:
=If(A1="",0,B2=$B$1)
As far as I understand your problem, you should try:
=If(A1="",0,$B$1)
[Update]
Have a look at this tool:
FormulaDesk - FormulaSpy[
^]