Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How do I write this formula in Excel?

=if(700>=700;"Saving";IF(700<>700-400;"average saving";If(700<=400;"Spender")))
share|improve this question
    
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. –  Julian Knight Mar 3 '13 at 22:10
    
I´m trying to find out how to put up the simbols between. IF(700<>700-400; –  Heida Mar 3 '13 at 22:22
    
Thank you. My english is not my best field, but I´m trying :) –  Heida Mar 3 '13 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. –  Julian Knight Mar 3 '13 at 22:26
add comment

1 Answer 1

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.

share|improve this answer
    
That was it :) Thank you. –  Heida Mar 3 '13 at 22:36
    
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 '13 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 '13 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 –  Robert Ilbrink Mar 4 '13 at 7:50
1  
@CarlB: Just a small side note: there are no accept rates displayed at SE anymore... –  Peter Albert Mar 4 '13 at 14:37
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.