Formula issues depending on the user

[Dee Dee]

Hi,

I am meeting a funny situation where there is a formula in AB that I can see, and it works fine, but when the other staff member opens it, she cannot see a result. She gets #NAME?. Is there something that I did to the file that causes this or can we save it differently?

Complaints Tracker - FY21 (1).xlsm
	Z	AA	AB
1	Date ROI Sent to Complainant/Rep	Date ROI Picked Up by Complainant/Rep (First Pick up Date)	30-day Due Date for Election
2	4/15/21	9/30/20	11/1/20
3	5/15/21	7/15/20	8/16/20
4		12/1/21	1/2/22
5		12/9/20	1/10/21
6
7
Formal Complaint Tracking

Cell Formulas
Range	Formula
AB2:AB7	AB2	=IFS(AA2<>"",AA2+32,AA2="","")

 

[Joe4]

Which version of Excel is she using?
As you can see here (IFS function), the IFS was recently introduced and only available of newer versions of Excel. If she does not have one of the versions listed, she will get those errors.

 

[Fluff]

You're co-worker is probably using an older version of Excel which doesn't have the IFS function.
That said, there is no need to use IFS you can just use

=IF(AA2<>"",AA2+32,"")

 

[JimM]

The IFS formula is only available on 'Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2019 '
Is your colleague on an older version?

 

[Dee Dee]

Which version of Excel is she using?
As you can see here (IFS function), the IFS was recently introduced and only available of newer versions of Excel. If she does not have one of the versions listed, she will get those errors.

Ill have to ask her. The thing is all the other functions in the sheet work. only that one is throwing an error.

 

[Joe4]

Ill have to ask her. The thing is all the other functions in the sheet work. only that one is throwing an error.

IFS is a new function. The other ones used in the worksheet probably aren't.
Fluff posted a workaround that you can use instead of your IFS function that will do the same thing, but not cause errors for the other user.

 

[Dee Dee]

Thank you. You were right. I fixed it. And there was one more just like you suggested. IFS was the issue.

You're co-worker is probably using an older version of Excel which doesn't have the IFS function.
That said, there is no need to use IFS you can just use

=IF(AA2<>"",AA2+32,"")

 

[Fluff]

Glad we could help & thanks for the feedback.