Formula is not working

[littlehelga]

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

 

[Jonmo1]

Welcome to the board.

Try

=MIN(5,J7)

 

[Fluff]

Hi & welcome to MrExcel
Try =IF(J7<5,J7,5)

 

[Joe4]

Welcome to the Board!

You do not want to use OR. You would just use:

=IF(J7>5,5,J7)

or even simpler:

=MIN(J7,5)

 

[littlehelga]

Welcome to the board.

Try

=MIN(5,J7)

Thanks!! That was an easy fix!

 

[Jonmo1]

You're welcome.

 

[littlehelga]

another stumble

J1=10
J8 = 8 (formula cell)
K7 = 0 (formuia cell)
I need to add J1 and K7 and subtract J8
when i enter the formula =(J1+K7-J8) the answer is wrong...it's giving me a zero.

am i entering it wrong??

 

[Joe4]

Make sure you actually are referencing the correct cells in your formulas.
What are your formulas in J8 and K7?
Also, you are not using merged cells, are you?

 

[littlehelga]

Make sure you actually are referencing the correct cells in your formulas.
What are your formulas in J8 and K7?
Also, you are not using merged cells, are you?

rechecked cells are correct for the formula


J8 is =SUM(C8:I8)
K7 is =MIN(5,J7)

No merged cells

 

[Joe4]

If the values are in the cells are really:
J1 = 10
J8 = 8
K7 = 0
Then there is no way that:
=(J1+K7-J8)
can return 0.

Are you sure that your calculation is not set to Manual?
What happens if you press F9?