View Single Post
 
Old 11-18-2022, 01:01 AM
Celo Celo is offline Windows 10 Office 2021
Novice
 
Join Date: Nov 2022
Posts: 1
Celo is on a distinguished road
Default Combine 2 formulas

Good morning
I have 2 formulas that work separately but I can't make 1 formula that works. Can anyone help? -
Big thanks in advance!

=IF(LEFT([@[Som ]];1)=">";[@[Som ]];IF(AND([@[KG 36 /0 ]]=">300";AND([@[KG 36 /-1 ]]>0));[@[Som ]]/0,1;IF(AND([@[KG 36 /0 ]]>0;OR([@[KG 36 /-1 ]]=0;[@[KG 36 /-1 ]]>0));[@[Som ]]/1,1)))


And:


IF(LEFT([@[Som ]];1)=">";[@[Som ]];IF(AND([@[KG 36 /0 ]];[@[KG 36 /-1 ]];[@[KG 36 /-2 ]]=">300";OR([@[KG 36 /-3 ]]>0));[@[Som ]]/0,001;IF(AND([@[KG 36 /0 ]];[@[KG 36 /-1 ]]=">300";AND([@[KG 36 /-2 ]];[@[KG 36 /-3 ]]>0));[@[Som ]]/0,011;IF(AND([@[KG 36 /0 ]]=">300";OR([@[KG 36 /-1 ]];[@[KG 36 /-2 ]];[@[KG 36 /-3 ]]>0));[@[Som ]]/0,111;IF(AND(OR([@[KG 36 /0 ]];[@[KG 36 /-1 ]];[@[KG 36 /-2 ]];[@[KG 36 /-3 ]]>=0));[@[Som ]]/1,111)))))
Reply With Quote