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

 

[littlehelga]

Calculations are set to automatic.
values are correct as shown

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?

 

[Jonmo1]

Maybe you're having a circular reference error.
Look on the Formulas Tab - Error checking.

Which cell are you putting this formula in?
Is J1 also a formula?

 

[littlehelga]

Error Checking - no error
J1 is not a formula
entering the formula in L7

 

[Joe4]

Can you upload the file to a file sharing site like "DropBox" and provide a link here, so we can download it and take a look at it?

 

[littlehelga]

https://www.dropbox.com/s/6bzw70vrlbbymnq/Vacation-Sick-Time Card.xlsx?dl=0

Thank you!

 

[Jonmo1]

You have custom formatting in K7 (#,##0;"0") that is making negative values appear to be 0.
K7 actually equals -6.

 

[littlehelga]

yes, I do remember now putting that in there when i was having difficulties...
how do i delete it?

 

[Jonmo1]

Just change the format of that cell to General, or Number.

 

[littlehelga]

thanks! everything is working now!

 

[Jonmo1]

You're welcome.