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...
You could always use ALT-0034.
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...
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...
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.
