-2

How do I write this formula in Excel?

=if(700>=700;"Saving";IF(700<>700-400;"average saving";If(700<=400;"Spender")))
4
  • No, sorry, don't understand. Can you please give some more context and explain what you mean by "put this formula up"? Welcome to SuperUser by the way. Mar 3, 2013 at 22:10
  • I´m trying to find out how to put up the simbols between. IF(700<>700-400;
    – Heida
    Mar 3, 2013 at 22:22
  • Thank you. My english is not my best field, but I´m trying :)
    – Heida
    Mar 3, 2013 at 22:25
  • Sorry, I'm still not getting you. The formula you have written can be typed directly into any cell except for the error in the last IF - you only have 2 parts to it instead of 3. It would be better if you explained what it is you are trying to achieve then I could lead you through it. Mar 3, 2013 at 22:26

1 Answer 1

8

I'm guessing that you want some cell to show "saving", "average" or "spender", depending on the value of some other cell. If that is correct, and the cell containing the value is A1, then the following will do the trick:

=IF(A1>700,"saving",IF(A1>400,"average","spender"))

If you put this in a cell, the cell will change from "average" to "saving" to "spender, depending on the value you put in A1. The formula compares A1 with 700:

  • If A1 is greater it displays "saving".
  • If A1 is not greater than 700, it next compares it with 400.
  • If A1 is greater than 400, it displays "average".
  • If A1 is not greater than 400, the display is "spender".

If my guess is incorrect, please explain what you require.

4
  • I thought I was thanking him "That was it :) Thank you."and I also want to thank the other people for trying to help me.
    – Heida
    Mar 4, 2013 at 0:09
  • 2
    @Heida- If hahondt's answer sloved your question, you should accept the answer (check mark option on your question) :)
    – Carl B
    Mar 4, 2013 at 0:28
  • 1
    @Heida, It is great that you thanked hdhondt, but that doesn't get him any credits. Please "Accept" that answer by clicking on the white check-mark next to the answer. This will mark the question as solved and it will give the credits to hdhondt. For the details see: meta.stackexchange.com/a/5235/210367 Mar 4, 2013 at 7:50
  • For the details see: Accepting Answers: How does it work?
    – Peter L.
    Mar 4, 2013 at 18:52

You must log in to answer this question.

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