Help with =IFS

[Mel Smith]

I am trying to write an =IFS function but I am getting the wrong answer. Can someone point me in the right direction, please?

=BK10-IFS(D10="ATU",--$G$188,33,--$G$189,35,--$G$190,"KIT",--$G$191,37,--$G$192,38,--$G$193,44,--$G$194)-$I$188

The expected answer and the result differs by £200.

I188 = £100
G188 = £175, G189 = £260, G190 = £460, G191 = £1087, G192 = £670, G193 = £2500 and G194 = £3000

Mam thanks.

Mel

 

[Fluff]

Maybe

=BK10-IFS(D10="ATU",--$G$188,d10=33,--$G$189,d10=35,--$G$190,d10="KIT",--$G$191,d10=37,--$G$192,d10=38,--$G$193,d10=44,--$G$194)-$I$188

 

[Mel Smith]

Perfect Fluff. Thank you!

Mel

 

[Fluff]

You're welcome & thanks for the feedback.