Microsoft Office Forums Combine 2 formulas
 Register FAQ Search Today's Posts Mark Forums Read

#1
11-18-2022, 01:01 AM
 Celo Windows 10 Office 2021 Novice Join Date: Nov 2022 Posts: 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? -

=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
11-18-2022, 01:36 AM
 Pecoflyer Windows 10 Office 2021 Expert Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,653

Hi
__________________
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
11-18-2022, 06:13 AM
 p45cal Windows 10 Office 2019 Expert Join Date: Apr 2014 Posts: 695

 Tags combine, formula

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post LearnerExcel Excel 2 12-27-2017 12:41 AM 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:14 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top