I am trying to create an IFS formula but it is not writing

[mwillard]

Formula being used is: libreoffice calc =IFS($B5=“Completed”,“20”,“0”,$D5=“Completed”,“20”,“0”)

The sheet is to keep track of patients I’ve called, if I was able to contact them they are completed and “Completed” is entered, if called but not contacted and I left message to call back then “LMTCB” is entered. If Completed then 20 is the length of minutes spent on call if LMTCB then 0 is the number of minutes on the call. If not called at all then it’s suppose to stay blank. The Formula is causing “#NA” on my blank ones

What am I doing wrong?

[mariosv]

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

[mwillard]

I went there first, wouldn’t have wasted my time creating a user name, password, and posting this question had I not already researched a solution. I have exhausted all resources and still no solution which is why I posted the question.

[LeroyG]

@mwillard

=IFS($B5=“Completed”,“20”…

We don’t know the layout of your spreadsheet, so I worked with this assumptions:

• In column B there is nothing or “Completed”
• In column D there is nothing or “LMTCB”

=IFNA(IFS($B5="Completed";20;$D5="LMTCB";0);"")

For more help, please, edit your question and share a sample file, so we are no guessing. Thanks.