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.


    Thank you in advance.


    Lok

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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!