Forum Discussion
Help with this "IFS" statement in office 365
I looked up how to write this statement, found a solution on the web (Example 2) see attached image I typed the exact same information into my spreadsheet using the formula shown. and get a differe...
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?
No this does not work without the quotation marks.
More testing required.
More testing required.
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.
