![]() |
#1
|
|||
|
|||
![]()
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))))) |
Tags |
combine, formula |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
LearnerExcel | Excel | 2 | 12-27-2017 12:41 AM |
Possible to combine 3 different workbooks? | markg2 | Excel | 5 | 11-14-2016 12:36 AM |
![]() |
lbf200n | Word VBA | 3 | 12-09-2012 04:22 PM |
![]() |
lwisniewski | Word VBA | 3 | 12-24-2010 03:45 PM |
![]() |
markg2 | Outlook | 2 | 04-26-2010 03:09 PM |