Skip to main content
Solved

IF Statement nested but different

  • November 16, 2020
  • 2 replies
  • 24 views
D

Hey People, i`m facing a problem i cant solve :frowning:

I want to calculate Taxes in my Base.

Ive got a checkbox called - SOLD
A base which is called - Bought from Private (BFP)
A Base called - Kommission
A field which hold the SALES
A Field which hold the amount of the kommission
A Field which hold the amount how much i paid for the article.

So i want to do this:

IF(SOLD, AND (BFP) -> calculate (SALES-Bought for)/11919, IF(SOLD, AND KOMMISSION -> calculate (SALES-KOMMISSION)/11919)

I cant find a solution to make the formulawork …

Thank you very much!!!

Best answer by Kamille_Parks11

Sounds like you need to do:

IF(
   AND({SOLD}, {BFP}),
   ({SALES-Bought for})/11919, 
   IF(
      AND({SOLD}, {KOMMISSION}, 
      ({SALES} - {KOMMISSION})/11919
   )
)

2 replies

Kamille_Parks11
Forum|alt.badge.img+27

Sounds like you need to do:

IF(
   AND({SOLD}, {BFP}),
   ({SALES-Bought for})/11919, 
   IF(
      AND({SOLD}, {KOMMISSION}, 
      ({SALES} - {KOMMISSION})/11919
   )
)
D
D
  • Dominik_Ledwon
  • Author
  • New Participant
  • November 16, 2020

THANK YOU very much <3

Was sitting on ik for like 2 hours :grinning_face_with_big_eyes:

Terms & ConditionsAccessibility statement