Need help with a IF Or formula

Copper 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