Forums

General Betting

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

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
sort by:
Show
per page
Replies: 1
By:
bushy
When: 14 Nov 09 14:26
=IF(C1 gt 100, C1-A1, "")

Replace gt with the greater than symbol which doesn't display properly on this forum.
sort by:
Show
per page

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
‹ back to topics
www.betfair.com