Excel Formula

1

100Kay

So far my formula says:

If(B16=5,550)

How do I incorprate an "or" phrase to say If (B16 or B20 =5, 550)

Thanks
 
N

Niek Otten

=IF(OR(B16=5,B20=5),550,"What now?")

Your formula is incomplete; what if neither is 5?
 

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

Still stumped 7
Copying a formula containing the INDIRECT function 7
If Statements 1
Vlookup #n/a 6
Conditional =CONCATENATE formula 2
Help me please, with a formula! 0
Or Function 6
Help with a formula (calculating totals based on individual percentages 7

Top