You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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.
