Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-18-2022, 01:01 AM
Celo Celo is offline Combine 2 formulas Windows 10 Combine 2 formulas Office 2021
Novice
Combine 2 formulas
 
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
  #2  
Old 11-18-2022, 01:36 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Combine 2 formulas Windows 10 Combine 2 formulas Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,653
Pecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud ofPecoflyer has much to be proud of
Default

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
Reply With Quote
  #3  
Old 11-18-2022, 06:13 AM
p45cal's Avatar
p45cal p45cal is offline Combine 2 formulas Windows 10 Combine 2 formulas Office 2019
Expert
 
Join Date: Apr 2014
Posts: 695
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default

probably being answered here:
answers.microsoft.com
Reply With Quote
Reply

Tags
combine, formula

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine 2 formulas 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
Combine 2 formulas Please help me to combine these code together lbf200n Word VBA 3 12-09-2012 04:22 PM
Combine 2 formulas Combine two forms into one lwisniewski Word VBA 3 12-24-2010 03:45 PM
Combine 2 formulas Combine pst files? 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.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft