IF function

[TrudeB]

If the totalt amount of money spent on shopping is over the discount limit at 2000NOK, the discount must be automatically deducted from the total. How do i have to write the function?

[#2]

@TrudeB 

=LET(s, SUM(D4:D6), rabatt, (s>=D10)*D11, s-rabatt)

=LET(s; SUMMER(D4:D6); rabatt; (s>=D10)*D11; s-rabatt)

[#3]

What do you think about this one?

"Hvis" = "If"

=HVIS((SUMMER(D4:D6))>=D10;SUMMER(D4:D6)+D11;SUMMER(D4:D6))

[#4 · Accepted solution]

@TrudeB 

Shouldn't that be

=HVIS((SUMMER(D4:D6))>=D10;SUMMER(D4:D6)-D11;SUMMER(D4:D6))

Alternatively

=SUMMER(D4:D6)-HVIS(SUMMER(D4:D6)>=10;D11;0)

or

=SUMMER(D4:D6)-(SUMMER(D4:D6)>=D10)*D11

[#5]

Ah, thank you Hans!
Yes, it should for sure be minus, not plus! I felt my function was way too long, so thank you for the alternatives they are great!