Hi all..
I'm trying to create a formula that will have the following example,
If B1 is lower than A1 then show B1.
If anybody knows how to do it please leave a comment..
Thank you very much in advance.
unsafe13 wrote:
If B1 is lower than A1 then show B1.
You can try something like this:
=IF(B1<A1,B1,"")
Or, if your region uses , as a decimal separator, you would use:
=IF(B1<A1;B1;"")
You can learn more about the IF function, with illustrative examples, here:
IF(if-expression, if-true, if-false)
I found that explanation, and many others, by going to Help > Formulas and Functions Help in the menu.
SG
unsafe13 wrote:
If B1 is lower than A1 then show B1.
You can try something like this:
=IF(B1<A1,B1,"")
Or, if your region uses , as a decimal separator, you would use:
=IF(B1<A1;B1;"")
You can learn more about the IF function, with illustrative examples, here:
IF(if-expression, if-true, if-false)
I found that explanation, and many others, by going to Help > Formulas and Functions Help in the menu.
SG
Thank you so much! that was rocket fast!
I followed the same way cause it's kind of common sense but the main problem that I faced in the first place was the region symbol.. The second way worked!!
thank you again
Create an IF formula for "greater than" in numbers.
