Forum Discussion
Solved
IF function
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?
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
4 Replies
=LET(s, SUM(D4:D6), rabatt, (s>=D10)*D11, s-rabatt)
=LET(s; SUMMER(D4:D6); rabatt; (s>=D10)*D11; s-rabatt)
- What do you think about this one?
"Hvis" = "If"
=HVIS((SUMMER(D4:D6))>=D10;SUMMER(D4:D6)+D11;SUMMER(D4:D6))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
