M Macie Joined Apr 27, 2016 Messages 1 Reaction score 0 Apr 27, 2016 #1 Return value "True" if either the number in C3 is greater than 1 or the number in D3 is greater than 500.00
Return value "True" if either the number in C3 is greater than 1 or the number in D3 is greater than 500.00
Becky Webmistress Joined Mar 25, 2003 Messages 7,424 Reaction score 1,511 Apr 28, 2016 #2 Welcome to the forum! This should do what you want: =IF(OR(C3>0,D3>500),"TRUE","FALSE")
bootneck02 Joined Jul 11, 2010 Messages 5,758 Reaction score 552 Apr 28, 2016 #3 Welcome to the club Macle