General Betting
There is currently 1 person viewing this thread.
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
TYIA
sort by:
Show
per page
Replies: 1
|
By:
=IF(C1 gt 100, C1-A1, "")
Replace gt with the greater than symbol which doesn't display properly on this forum. |