 • 464K Members
• 11.2K Online
• 560K Conversations
SOLVED

# IF Function

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

# Re: IF Function

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))

# Re: IF Function

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

Solution

# Re: IF Function

More exactly

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

# Re: IF Function

Thank you very much!  This worked perfectly!!

# Re: IF Function

You are welcome

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies