Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I keep getting a message that I have too many arguments. I am trying to ask: If value 1 = x, then value 2; otherwise value 3. BUT if value 3 = 0, then blank.

It doesn't like:

=IF($AX7="SFDC",Z7,AA7,"")  

It doesn't like:

=IF($AX7="SFDC",Z7,AA7,IF(AA7="0",""))

I don't know how to ask this question. Can you help? What am I doing wrong? Thank you.

share|improve this question

The IF function takes three arguments, not four. Your second try had the right idea, but you need to move the second IF to the 3rd argument.

=IF($AX7="SFDC",Z7,IF(AA7="0","",AA7))
share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .