Forum Discussion
Help with this "IFS" statement in office 365
How would I know if i am using 34
The only key on the keyboard that has any similarity to this, is " the key next to the left of the return key.
Also if I am using this key stroke what defines it?
It is getting curious and curiouser!
Yes, Mac is still another world.
By the way, i copy/pasted quotes from around No match
=IFS(AND(B3=“FRINGE”,E8=2),15,AND(B3=“FRUGAL”,E8=3),25,AND(B3=“GEO”,E8=1),15,TRUE,"No match")
to
=IFS(AND(B3="FRINGE",E8=2),15,AND(B3="FRUGAL",E8=3),25,AND(B3="GEO",E8=1),15,TRUE,"No match")
and formula works (don't know what shall be the result, but at least #NAME? disappeared).
I guess we need an expert on Mac.
- I tried using Control-0034
Option-0034
Command-0034
Control+Control-0034
Control+Option-0034
Control+Command-0034
Option+Command-0034
You see I do not have a ALT key
Yes I know it is a mac... You could always use ALT-0034.
- No this does not work without the quotation marks.
More testing required. Hi Sergei,
I have tried doing that
1 on my imac only 1 key for open Quotation marks " which is [shift"]
I have tried all other keys to no success to find there is only the one "
This is what I have been using all along with the result in the formula being #NAME?
Could this work if I take the quotation marks out all together?
