Home

Need help with a IF Or formula

%3CLINGO-SUB%20id%3D%22lingo-sub-927927%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20a%20IF%20Or%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-927927%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%202%20checkboxes%20that%20are%20associated%20with%20D3%20and%20D4.%3C%2FP%3E%3CP%3EI%20also%20have%20a%20value%20in%20H3%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20cell%20G12%26nbsp%3BI%20am%20needing%20a%20formula%20that%20will%3A%26nbsp%3B%20IF%20D3%20or%20D4%20is%20True%20then%20multiply%20H3%20by%20.36%3C%2FP%3E%3CP%3EIf%20neither%20box%20is%20checked%20then%20value%20is%200%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20advance%3C%2FP%3E%3CP%3ESue%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-927927%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-928006%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20a%20IF%20Or%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-928006%22%20slang%3D%22en-US%22%3E%3DIF(OR(D3%2CD4)%2CH3*0.36%2C0)%3CBR%20%2F%3E%3CBR%20%2F%3EAt%20least%20that%20worked%20for%20me%20if%20the%20values%20in%20either%20D3%20or%20D4%20were%20either%20%22TRUE%22%20or%201%3CBR%20%2F%3EZero%20or%20blank%20left%20G3%20as%200%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-928052%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20a%20IF%20Or%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-928052%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much.%26nbsp%3B%20It%20works%20perfectly!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESue%3C%2FP%3E%3C%2FLINGO-BODY%3E
sue_F530
New Contributor

I have a 2 checkboxes that are associated with D3 and D4.

I also have a value in H3

 

 

In cell G12 I am needing a formula that will:  IF D3 or D4 is True then multiply H3 by .36

If neither box is checked then value is 0

 

Thank you advance

Sue

 

2 Replies
=IF(OR(D3,D4),H3*0.36,0)

At least that worked for me if the values in either D3 or D4 were either "TRUE" or 1
Zero or blank left G3 as 0

@mathetes 

 

Thank you so much.  It works perfectly!

 

Sue

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