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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
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: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
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 04:19 AM.


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