#1
|
|||
|
|||
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))))) |
#2
|
||||
|
||||
Hi
please post a sample sheet ( no pics please). Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
||||
|
||||
probably being answered here:
answers.microsoft.com |
Tags |
combine, formula |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to combine these formulas into one? | LearnerExcel | Excel | 2 | 12-27-2017 12:41 AM |
Possible to combine 3 different workbooks? | markg2 | Excel | 5 | 11-14-2016 12:36 AM |
Please help me to combine these code together | lbf200n | Word VBA | 3 | 12-09-2012 04:22 PM |
Combine two forms into one | lwisniewski | Word VBA | 3 | 12-24-2010 03:45 PM |
Combine pst files? | markg2 | Outlook | 2 | 04-26-2010 03:09 PM |