SOLVED

Multiple Conditional Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2775247%22%20slang%3D%22en-US%22%3EMultiple%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2775247%22%20slang%3D%22en-US%22%3EHey%20guys%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20it%20possible%20to%20have%20multiple%20conditions%20within%20a%20Conditional%20Formula%20to%20show%2Fhide%20a%20column%20but%20only%20if%20all%20conditions%20are%20true%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20know%20you%20can%20do%20it%20for%20if%20either%20are%20true%20but%20I%20need%20both%20conditions%20to%20be%20true%20and%20one%20is%20also%20a%20number%20column.%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20an%20example%20of%20what%20I%20need%20is%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3DIf(%5B%24Order%5D%3D%3D%E2%80%98Buy%E2%80%99%20ll%20%5B%24Inventory%5D%20%26gt%3B%3D2%2C%20%E2%80%98true%E2%80%99%2C%20%E2%80%98false%E2%80%99)%3CBR%20%2F%3E%3CBR%20%2F%3EMany%20thanks.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2775247%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2775524%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Conditional%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2775524%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1163623%22%20target%3D%22_blank%22%3E%40LCarroll5554%3C%2FA%3E%26nbsp%3Buse%20%26amp%3B%26amp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2777417%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Conditional%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2777417%22%20slang%3D%22en-US%22%3E%3CP%3EMany%20thanks%20Rob%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hey guys

Is it possible to have multiple conditions within a Conditional Formula to show/hide a column but only if all conditions are true?

I know you can do it for if either are true but I need both conditions to be true and one is also a number column.

So an example of what I need is:

=If([$Order]==‘Buy’ ll [$Inventory] >=2, ‘true’, ‘false’)

Many thanks.
2 Replies
best response confirmed by LCarroll5554 (New Contributor)
Solution

@LCarroll5554 use &&

Many thanks Rob :)