Using =@IFS in formula bar

[ndtsteve]

Dear Forum,

Using a formula which worked for me when using Win7 and Excel 2016 but now doesn't seem to work now my laptop has been 'upgraded' due to company policy to Win10 and Office 365 ProPlus ti doesn't work??

Attached is simple version of what I'm trying to achieve with comments showing my expected result. Maybe there is a better way to achieve my end result?
Please can someone look at my demo attachment and tell me where I'm going wrong.........probably something stupid

Apologies for post title as I just can't think of a succinct/correct terminology to explain it.

[Gregb11]

In D4, your formula has an "@" (at) sign in it. I believe Excel does that depending on if a formula is valid in that version. Also, the words Domestic and International didn't have quotes around them in the formula.
So D4 is now:
=IFS($A$1="DOMESTIC",H4,$A$1="INTERNATIONAL",I4,TRUE,"")
This can be copied down the list.
The ones that are multiplied by D2 can have a formula of:
=IFS($A$1="DOMESTIC",H7*$D$2,$A$1="INTERNATIONAL",I7*$D$2,TRUE,"")

If there is some logic that determines if it's multiplied by D2, then that can be added so that only 1 formula is used for the whole column.

[ndtsteve]

Thank you very much Gregb11, much appreciated.
Strangely, I never had the DOMESTIC in quotes on my other workbook that I adapted for this workbook, it worked without the quotes?!?!?!

[Gregb11]

I think the only way that would have worked is if you went to Name Manager and named 2 cells Domestic and International (like naming cells L3 and L4).