While in Google sheets, I have found this formula to work perfect:

**=**

**if((B2/100)>C2,C2,floor(B2/100)**

**)**

However, while in Excel, it will not work and I can't figure out why.

Any help will be much appreciated!

**Thank you in advance**

More Info:

Every registered Walker that raises $100 or more will get a t-shirt. For teams, t-shirts are distributed based on the amount of money they raise, capped by the number of members on the team. For example, a team of 10 that raises $800 would get eight shirts. A team of 10 that raises $1,200 would get 10 shirts.

More Info:

Every registered Walker that raises $100 or more will get a t-shirt. For teams, t-shirts are distributed based on the amount of money they raise, capped by the number of members on the team. For example, a team of 10 that raises $800 would get eight shirts. A team of 10 that raises $1,200 would get 10 shirts.

Team Name | Amount Raised | # Team Members | Shirts Earned |

Walk It Out | $190.14 | 2 | 1 |

Walkie Talkies | $385.25 | 5 | 3 |

Walking Warriors | $2,500.06 | 8 | 8 |

<tbody>

</tbody>