Forum Discussion
IFS getting #NAME? on Mac Excel V 16.37
I have a multi worksheet file in which I want to fill two boxes conditionally across workbooks drawing from two lists. When I got #NAME? I thought it was due to long, complicated formula with all the referenced sheets. So I simplified a trial on a blank page, and the result is the same. What am I missing?
It's not IFS, but the text value A - it should be enclosed in ":
=IFS(B2="A",2,B2=B3,D3,...)
(Weird formula, by the way)
2 Replies
It's not IFS, but the text value A - it should be enclosed in ":
=IFS(B2="A",2,B2=B3,D3,...)
(Weird formula, by the way)
(Smacks head) I figured that out about a minute after I posted.
I have a golf tournament spread sheet and the handicaps get applied per person across games, so Name = Specific Course Handicap. This helps me just put in a name and the handicap auto populates.
Thanks for the response!
