Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: IF Statement nested but different

Solved
Jump to Solution
815 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Dominik_Ledwon
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

Sounds like you need to do:

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

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

Sounds like you need to do:

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

THANK YOU very much ❤️

Was sitting on ik for like 2 hours :grinning_face_with_big_eyes: