| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need an answer display in one cell if (=), but another if (-)
I have an Excel spreadsheet where there is a "Charges" column and a "Credits"
column. I am multiplying the per diem by the days. If it's a positive number I want the value in the "Charges" column. If it's a negative value I want it in the "Credits" column. Can anyone suggest a formula to do this? COUNTY 365 BASE $5,452.78 Per Diem: $14.94 FROM 07/01/08 TO 08/30/07 Days: (306) ($4,571.37) Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need an answer display in one cell if (=), but another if (-)
A formula cannot "push" values to another cell, so in the Charges
column use this formula: =MAX(per_diem*days,0) In the Credits column use this: =MIN(per_diem*days,0) Substitute the appropriate cell references and copy down as required. Hope this helps. Pete On Oct 29, 6:43 pm, LeslieD wrote: I have an Excel spreadsheet where there is a "Charges" column and a "Credits" column. I am multiplying the per diem by the days. If it's a positive number I want the value in the "Charges" column. If it's a negative value I want it in the "Credits" column. Can anyone suggest a formula to do this? COUNTY 365 BASE $5,452.78 Per Diem: $14.94 FROM 07/01/08 TO 08/30/07 Days: (306) ($4,571.37) Thank you! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need an answer display in one cell if (=), but another if (-
Thank you very much! That did the trick :o)
"Pete_UK" wrote: A formula cannot "push" values to another cell, so in the Charges column use this formula: =MAX(per_diem*days,0) In the Credits column use this: =MIN(per_diem*days,0) Substitute the appropriate cell references and copy down as required. Hope this helps. Pete On Oct 29, 6:43 pm, LeslieD wrote: I have an Excel spreadsheet where there is a "Charges" column and a "Credits" column. I am multiplying the per diem by the days. If it's a positive number I want the value in the "Charges" column. If it's a negative value I want it in the "Credits" column. Can anyone suggest a formula to do this? COUNTY 365 BASE $5,452.78 Per Diem: $14.94 FROM 07/01/08 TO 08/30/07 Days: (306) ($4,571.37) Thank you! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need an answer display in one cell if (=), but another if (-
Glad to hear it - thanks for feeding back.
Pete "LeslieD" wrote: Thank you very much! That did the trick :o) "Pete_UK" wrote: A formula cannot "push" values to another cell, so in the Charges column use this formula: =MAX(per_diem*days,0) In the Credits column use this: =MIN(per_diem*days,0) Substitute the appropriate cell references and copy down as required. Hope this helps. Pete On Oct 29, 6:43 pm, LeslieD wrote: I have an Excel spreadsheet where there is a "Charges" column and a "Credits" column. I am multiplying the per diem by the days. If it's a positive number I want the value in the "Charges" column. If it's a negative value I want it in the "Credits" column. Can anyone suggest a formula to do this? COUNTY 365 BASE $5,452.78 Per Diem: $14.94 FROM 07/01/08 TO 08/30/07 Days: (306) ($4,571.37) Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas display 0 instead of answer | Excel Discussion (Misc queries) | |||
| how do i use 'if' command to display answer in different cell? | Excel Discussion (Misc queries) | |||
| the answer dont display just the formula i input help | New Users to Excel | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
| display the answer for a formula from another page? | New Users to Excel | |||
Linear Mode
