Forum Discussion
Amber Morton
Oct 29, 2017Copper Contributor
Nested IF Statement?
I need to use the If statement Dialog Box to enter Increased as "Increased" and Decreased as "Decreased" so that text will be the result. What formula would I use and how would I type that in to accomplish this. Thank you!
1 Reply
Sort By
Hello,
are you referring to the dialog box that appears when you enter a formula via Formulas > Logical > If?
In that dialog you need to enclose text in double quotes.
You can write the formula without the dialog, too. Just type this into a cell:
=IF(B1>A1,"Increased","Decreased")
does that help?