How do I write this formula in Excel?
=if(700>=700;"Saving";IF(700<>700-400;"average saving";If(700<=400;"Spender")))
How do I write this formula in Excel?
=if(700>=700;"Saving";IF(700<>700-400;"average saving";If(700<=400;"Spender")))
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:
A1
is greater it displays "saving".A1
is not greater than 700, it next compares it with 400.A1
is greater than 400, it displays "average".A1
is not greater than 400, the display is "spender".If my guess is incorrect, please explain what you require.