Forum Discussion
IFS function with sheet link
Hi all In an IFS function I want to have the return values from a different worksheet - but don't know whether this is not possible (no examples show this) or there is a simple novices error in my c...
As a comment, IFS() shall work on Mac same way as on Windows, i.e. only for Office 365 subscribers or on Excel 2019 for Mac.
#NAME! error could be not only since function doesn't exist, but as well if within formula appears curly quote character ” instead of straight quote ".
Sergei ..wow i had no idea that the quote characters were different and have never seen this mentioned but now it explains why i couldn't see how the suggestion differed from my now.. many thanks
Yes, they have different meaning and quite often straight quote is converted into curly one if copy/paste formula from the web. Just be careful with this.
- exactly what i had done! merci beaucoup!