Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

IF Statement nested but different

Topic Labels: Base design
Solved
Jump to Solution
383 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

Sounds like you need to do:

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

THANK YOU very much ❤️

Was sitting on ik for like 2 hours :grinning_face_with_big_eyes: