Excel: Formula is not working


I'm new to excel I am using this formula =IF(OR(J7<5, J7>5), J7, 5) If J7 is less than 5, I want it to remain J7 If J7 is greater than 5, I want it to remain 5


This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of January 29, 2018.


For more resources for Microsoft Excel