IF Statement nested but different

[Dominik_Ledwon]

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!!!

[Kamille_Parks · Accepted solution]

Sounds like you need to do:

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

[Dominik_Ledwon]

THANK YOU very much ❤️

Was sitting on ik for like 2 hours :grinning_face_with_big_eyes: