# Hiding a cell if value equals X

Solved/Closed
Related:

- Hiding a cell if value equals X
- How to know if someone hide their story from you on instagram - Guide
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
- Conditional formatting if cell contains text - Excel Forum

## 1 response

Use the IF function:

=IF(35+((C5-1)*3,8)<35;0;35+((C5-1)*3,8))

If the result of your formula is smaller then 35 then display a 0,

If the result of your formula is the same or bigger then 35 then display the result of your formula.

Hope this is what you were looking for.

Best regards,

Trowa

Jul 22, 2009 at 12:45 AM

Thanks for your help! New it would need an IF formula but had no clue how to word it!

Yours looks like it should work, but when I try type it in excel it gives me an error saying that "The formula you typed contains an error" any ideas on why?

Really hope you can help!

Aimee

Jul 22, 2009 at 01:24 AM

Tried it again and it does work!

Thanks a million!

Jul 22, 2009 at 01:28 AM

Worked out what was wrong, in your formula you had ; where it should of been , !

So happy to finally have the answer to this! You are a lifesaver!