Forums

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