Hi support and all
In a numeric field I applied below formula
IFS(COUNTIF(C15,‘JJ shipping’,C15),5000,COUNTIF(C15,‘AAトランスポート’,C15),10000,0)
C15 is a selection field to enter transporter’s name.
If it’s JJ shipping they charge 5000 and AA Transport 10000 and that’s how I want to dictate the cost in the numeric field.
I just don’t get why this formula won’t work.
Is it because the counting text contains Japanese?(“トランスポート”=transport)
or that the COUNTIF function works differetly thatn Excel, cannot use as just a criteria of (if A field contains “B”), and actually counting sum of macthed?
I also tried LOOKUP formula but when I try
LOOKUP(C15,[‘JJ shipping’,‘AA トランスポート’],[5000,10000])
All the results will be 10000.