formual help
in cell B1 enter the formula
=IF(A1-616.670,"",A1-616.67)
and cell C1 enter
=IF(A1-616.67<0,"",A1-616.67)
--
...
"Smilen2day" wrote:
I have a spread sheet that I am working on. When I enter an amount in column
A, I want a formula so that it will take the number I enter minus 616.67.
And if the sum is a negative amount I want the sum to enter in column b, but
if the sum is a positive amount I want the sum to enter in column c.
How do I do this?
|