How to use IF and OR function together

M

Macie

Joined
Apr 27, 2016
Messages
1
Reaction score
0
Return value "True" if either the number in C3 is greater than 1 or the number in D3 is greater than 500.00
 
Becky

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
Welcome to the forum! This should do what you want:

=IF(OR(C3>0,D3>500),"TRUE","FALSE")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Excel Formula or equation 3
Finding value using greater than, Vlookup, and nested If 2
Excel Help to copy information from one row at a time to another sheet 1
Excel Conditioning Formatting 3
if formula needed 6
Conditional Format-should be an easy answer 1
if function 1

Top