# Show zero or blank or value based on multiple conditions

• Dear all,
I am having aproblem with IF function to show either 0 or Blank or Value in a cell based on condition.
Example:
If A2=0 or A2="" or A2=15, AND A4=0 or A4="" or A4=60,then I want to show the result in A5 based on the entry made in A2 and A4 as follows:
IF(A2=0,0,IF(A2="","",IF(A4=0,0,IF(A4="","",(A2+A4*.3))))
User may enter 0 or leave blank or enter any value in A2 and A4.
I would appreciate if someone could help me on this formula or any other related formulae to get the result.

Lok

• 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,

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.