Formula showing FALSE

[Hazeyt]

Please can someone tell me what I am doing wrong with my formula.

=IF([@[Absence Type]]="Sick Leave",IF([@[Total Days Lost]]>27,"Long",IF([@[Total Days Lost]]<=27,"Short","")))

I have the above formula in to show if the total days lost are Long Term or Short Term but for the Absence Type Sick Leave only

The formula is working but other Leave (example annual leave) is showing FALSE. I need this cell to be blank.

Thanks

 

[Fluff]

How about

=IF([@[Absence Type]]="Sick Leave",IF([@[Total Days Lost]]>27,"Long",IF([@[Total Days Lost]]<=27,"Short","")),"")

 

[Joe4]

You have nested multiple IF statements, but did not include values for all the FALSE portions of your formulas.
When that happens, and one of them evaluates to a FALSE argument for which no value is specified for the FALSE argument, it will return FALSE.
See if this fixes it:

=IF([@[Absence Type]]="Sick Leave",IF([@[Total Days Lost]]>27,"Long",IF([@[Total Days Lost]]<=27,"Short","")),"")

 

[Hazeyt]

How about

=IF([@[Absence Type]]="Sick Leave",IF([@[Total Days Lost]]>27,"Long",IF([@[Total Days Lost]]<=27,"Short","")),"")

It worked, thank you so much

 

[Hazeyt]

You have nested multiple IF statements, but did not include values for all the FALSE portions of your formulas.
When that happens, and one of them evaluates to a FALSE argument for which no value is specified for the FALSE argument, it will return FALSE.
See if this fixes it:

=IF([@[Absence Type]]="Sick Leave",IF([@[Total Days Lost]]>27,"Long",IF([@[Total Days Lost]]<=27,"Short","")),"")

It worked, thank you so much

 

[Fluff]

Glad we could help & thanks fr the feedback.