Thread
:
formual help
View Single Post
#
2
Posted to microsoft.public.excel.programming
Sandy Mann
external usenet poster
Posts: 2,345
formual help
Number in A2 formula in B2:
=IF(A2-616.67<0,A2-616.67,"")
In C2 enter:
=IF(A2-616.67=0,A2-616.67,"")
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Smilen2day" wrote in message
...
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?
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann