Thread: formual help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Smilen2day Smilen2day is offline
external usenet poster
 
Posts: 9
Default formual help

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?