Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 16, 2020 08:34 AM
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!!!
Solved! Go to Solution.
Nov 16, 2020 09:10 AM
Sounds like you need to do:
IF(
AND({SOLD}, {BFP}),
({SALES-Bought for})/11919,
IF(
AND({SOLD}, {KOMMISSION},
({SALES} - {KOMMISSION})/11919
)
)
Nov 16, 2020 09:10 AM
Sounds like you need to do:
IF(
AND({SOLD}, {BFP}),
({SALES-Bought for})/11919,
IF(
AND({SOLD}, {KOMMISSION},
({SALES} - {KOMMISSION})/11919
)
)
Nov 16, 2020 09:23 AM
THANK YOU very much ❤️
Was sitting on ik for like 2 hours :grinning_face_with_big_eyes: