Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
formual help
Formula in B1:
=MIN(A1-616.67,0) Formula in C1 =MAX(A1-616.67,0) copy both downwards. HTH. Best wishes Harald "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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
formual help
Awesome, Thank you so much.
One other question. Is there a way to hide the -616.67 in column B until an amount is entered in column A. For instance: I am doing a yearly pay register and have the formulas set up for the year. If we are in June now, we have not paid for July thru Dec, but it is showing a negative number of 616.67. Is there a way to make it be blank until an amount is enter in column A for it to subtract the 616.67 from? I hope that makes sense. "Sandy Mann" wrote: 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? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
formual help
=IF(A2="","",IF(A2-616.67<0,A2-616.67,""))
Rick "Smilen2day" wrote in message ... Awesome, Thank you so much. One other question. Is there a way to hide the -616.67 in column B until an amount is entered in column A. For instance: I am doing a yearly pay register and have the formulas set up for the year. If we are in June now, we have not paid for July thru Dec, but it is showing a negative number of 616.67. Is there a way to make it be blank until an amount is enter in column A for it to subtract the 616.67 from? I hope that makes sense. "Sandy Mann" wrote: 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? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
formual help
=IF(A2="","",if(A2-616.67<0,A2-616.67,""))
-- Saludos.. "Smilen2day" wrote: Awesome, Thank you so much. One other question. Is there a way to hide the -616.67 in column B until an amount is entered in column A. For instance: I am doing a yearly pay register and have the formulas set up for the year. If we are in June now, we have not paid for July thru Dec, but it is showing a negative number of 616.67. Is there a way to make it be blank until an amount is enter in column A for it to subtract the 616.67 from? I hope that makes sense. "Sandy Mann" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
some help with an IF formual or something like it | Excel Worksheet Functions | |||
WHAT DOES FORMUAL =C8+ 15 DO | Excel Discussion (Misc queries) | |||
Formual | Excel Discussion (Misc queries) | |||
Set Formual | Excel Discussion (Misc queries) | |||
what is mean by ^ in formual | Excel Programming |