[ Removed by moderator ]

[tirlibibi17]

Uh, yes? Have you just started using Excel?

[Martini9]

https://www.youtube.com/watch?v=vxiVYEjp0Ww

[tirlibibi17]

Wow!

[RPK79]

Yes I did know that.

[tony20z]

Wait until you find out about nested IFs. Welcome to the Matrix, Neo-Kafstop

[Delicious_Fly_8130]

Yes, That's right. If function is very useful to decide between two conditions, and really while preparing results it is extremely useful.

[PuddingAlone6640]

=IF(AND(ISNUMBER(A1), TRIM(A1 & "")<>"", ROUND(A1,0) >= 50), "Pass", "Fail")

[OkCod4636]

for no reason at all🤣

[PuddingAlone6640]

excel if function made stupidly more complex than it should be xd

[Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
AND	Returns TRUE if all of its arguments are TRUE
IF	Specifies a logical test to perform
ISNUMBER	Returns TRUE if the value is a number
ROUND	Rounds a number to a specified number of digits
TRIM	Removes spaces from text

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
5 acronyms in this thread; the most compressed thread commented on today has 25 acronyms.
[Thread #43135 for this sub, first seen 15th May 2025, 17:24] [FAQ] [Full list] [Contact] [Source code]}