SOLVED
Home

IF Function

%3CLINGO-SUB%20id%3D%22lingo-sub-360848%22%20slang%3D%22en-US%22%3EIF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360848%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day!%26nbsp%3B%20I%20was%20wondering%20if%20anyone%20knew%20how%20to%20do%20an%20IF%20function%20for%20the%20attached%20file.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20get%20the%20amount%20in%20column%20D%20to%20be%20%22950%22%20if%20column%20B%20or%20C%20has%20a%201%20in%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20B%20or%20C%20has%20any%20other%20number%2C%20then%20i%20need%20the%20formula%20to%20calculate%20the%20pounds%20using%20those%20numbers.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EB%20and%20C%20are%20the%20number%20of%20bins%20received%20and%20F%20and%20G%20are%20the%20number%20of%20bins%20remaining%20in%20inventory%2C%20but%20i%20need%20to%20put%20a%20weight%20to%20those%20bins%20in%20inventory.%26nbsp%3B%20Any%20help%20is%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-360848%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-361171%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-361171%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-361160%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-361160%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20very%20much!%26nbsp%3B%20This%20worked%20perfectly!!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-361048%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-361048%22%20slang%3D%22en-US%22%3E%3CP%3EMore%20exactly%3C%2FP%3E%0A%3CPRE%3E%3DIF(OR(B2%3D1%2CC2%3D1)%2C950%2CS2%2F(B2%2BC2))%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-360907%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360907%22%20slang%3D%22en-US%22%3E%3CP%3E(%20I%20think%20)%26nbsp%3B%20D2%20%3A%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3DIF(AND(B2%3D1%2CC2%3D1)%2C950%2CS2%2F(B2%2BC2))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-360905%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360905%22%20slang%3D%22en-US%22%3EFrom%20what%20I%20understand%2C%20you%20want%20Column%20D%20to%20return%3A%3CBR%20%2F%3E950%2C%20if%20the%20values%20of%20Column%20B%20and%20C%20are%200%3B%20otherwise%2C%3CBR%20%2F%3EColumn%20S%20divided%20by%20the%20sum%20of%20Column%20B%20and%20C.%3CBR%20%2F%3EThe%20formula%20in%20D2%20is%3A%3CBR%20%2F%3E%3DIF(AND(B2%3D0%2CC2%3D0)%2C%3CBR%20%2F%3E950%2C%3CBR%20%2F%3ES2%2F(B2%2BC2))%3CBR%20%2F%3EThe%20Boolean%20version%20is%3A%3CBR%20%2F%3E%3DIF((B2%3D0)*(C2%3D0)%2C%3CBR%20%2F%3E950%2C%3CBR%20%2F%3ES2%2F(B2%2BC2))%3C%2FLINGO-BODY%3E
chofbauer
New Contributor

Good day!  I was wondering if anyone knew how to do an IF function for the attached file.  

 

I am trying to get the amount in column D to be "950" if column B or C has a 1 in it. 

 

If B or C has any other number, then i need the formula to calculate the pounds using those numbers. 

 

B and C are the number of bins received and F and G are the number of bins remaining in inventory, but i need to put a weight to those bins in inventory.  Any help is greatly appreciated.

5 Replies
From what I understand, you want Column D to return:
950, if the values of Column B and C are 0; otherwise,
Column S divided by the sum of Column B and C.
The formula in D2 is:
=IF(AND(B2=0,C2=0),
950,
S2/(B2+C2))
The Boolean version is:
=IF((B2=0)*(C2=0),
950,
S2/(B2+C2))

( I think )  D2 :    =IF(AND(B2=1,C2=1),950,S2/(B2+C2))

Solution

More exactly

=IF(OR(B2=1,C2=1),950,S2/(B2+C2))

Thank you very much!  This worked perfectly!! 

You are welcome