Forums

We want to share an important update with our Betfair Community users.

Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.

Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.

To share your feedback and experience, visit: https://support.betfair.com/app/home

General Betting

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
CoCo Kukar
14 Nov 09 14:22
Joined:
Date Joined: 22 Jul 06
| Topic/replies: 121 | Blogger: CoCo Kukar's blog
I got a problem putting a formula in a cell. What I want is a cell value minus another cell value only if the the first cell has a number larger than 100. So for example I want =C1-A1 If C1100 in a new cell. When I put that =C1.... in, it says it is not typed right. Anyone know precisely what to type in?

TYIA
Show More
Loading...
Report bushy • November 14, 2009 2:26 PM GMT
=IF(C1 gt 100, C1-A1, "")

Replace gt with the greater than symbol which doesn't display properly on this forum.
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com