# Conditional Formula

**URL:** <https://forums.knack.com/t/conditional-formula/7294>\
**Category:** Get Answers\
**Created:** [September 8, 2017, 6:52pm UTC](https://forums.knack.com/t/conditional-formula/7294 "2017-09-08T18:52:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ChrisGebha91320](https://avatars.discourse-cdn.com/v4/letter/c/6f9a4e/32.png) [@ChrisGebha91320](https://forums.knack.com/u/ChrisGebha91320)\
**Post date:** [September 8, 2017, 6:52pm UTC](https://forums.knack.com/t/conditional-formula/7294/1 "2017-09-08T18:52:28Z")

</div>

I'm trying to take a numeric field value and "cap it". Basically if the value of the 1st field is more than 250, use 250 instead of the orginal number.

What I currently have is {Fee} \> 250 ? :250

but all this is returning is a 1 instead of 250 for a fee of 4363.84. What am I doing wrong?

---

<div class="post-metadata">

**Author:** ![ChrisGebha91320](https://avatars.discourse-cdn.com/v4/letter/c/6f9a4e/32.png) [@ChrisGebha91320](https://forums.knack.com/u/ChrisGebha91320)\
**Post date:** [September 8, 2017, 7:42pm UTC](https://forums.knack.com/t/conditional-formula/7294/2 "2017-09-08T19:42:26Z")

</div>

Never mind - figured it out with

{Fee} \> 250 ? 250 : {Fee}