Show zero or blank or value based on multiple conditions

Re: IF function

Hi Loknath:

Try this:

=IF(AND(A2="",A4=""),"",IF(AND(A2=0,A4=0),0,A2+A4))

Regards

Maqbool

Re: Show zero or blank or value based on multiple conditions

loknath,

Please be more precise with your thread titles and keep the following in mind when giving your thread a title in the future.

Thread titles are used in searching the forum, therefore, it is vital they be written to accurately describe your [COLOR="blue"]thread content or overall objective[/COLOR] using ONLY search friendly key words. That is, your title use as search terms would return relevant results.

• The title must not use non-essential words such as:"Help needed", "Formula problem", "Please help", "urgent", "Code issue", "Need Advice", etc. Such words dilute the title/search results.
• The title should not contain VBA code or formula syntax or use abbreviations, jargon, delimiters (e.g. slashes, commas, colons, etc)
• The title should not contain reference to VBA error messages as these are too generic to define the specific problem
• The title should not assume or anticipate a solution as in referencing Excel functions or VBA methods - the actual solution is often quite different
• The title should not contain special characters such as < > ~ ! @ # $ % ^ & * ( ) or math operators - these are not search friendly

Your title of "[COLOR="red"]IF Function[/COLOR]" does not describe your thread or objective and is not helpful to those searching the forum for a solution to a similar need.

[COLOR="darkred"]Please note the change to your title, which is based on the objective stated in your thread.[/COLOR]

If the new title still does not accurately describe your thread you may make further edits as needed per the above guidelines.