"IF" Formula Help

  • Thread starter Thread starter Korgan26
  • Start date Start date
K

Korgan26

Here is the starting of my formula.
=IF(I12>I69,I69.I12)
My problem is that if I69 is empty I want it to return I12.
How can I get it to do that?
Thanks
 
Try: =IF(OR(I12<=I69,I69=""),I12,I69)

or : =IF(I69="",I12,IF(I12>I69,I69,I12))
 

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

conditional formulas 4
Edit my Macro 3
help 2
Conditional Format - 3 conditions 3
Add Condition to Formula 2
Formula for summing cells that may be deleted 4
MATCH? 2
Applying Logic 2

Back
Top