I'm trying to set up a formula where the result is blank until other conditions are met. For example, if(A1>B1,"W","L")if(A1="","") Thank you.

JPL1986 · February 21, 2021, 7:10am

For example, if(A1>B1,“W”,“L”)if(A1="","") Thank you.

Grantler · February 21, 2021, 8:03am

=IFS()

could be helpful for you.

https://help.libreoffice.org/7.0/en-US/text/scalc/01/func_ifs.html?DbPAR=CALC#bm_id901556242230198

LeroyG · February 21, 2021, 12:27pm

What advantage/s does IFS have over nested IF? Say: =IF(A1="","";IF(A1>B1,"W","L")). Thanks.

anon73440385 · February 21, 2021, 10:44am

Hello,

try: =IFS(ISBLANK(A1);"";A1>B1;"W";A1<=B1;"L";1;"")