| 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! |
| 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 | |||
Threaded Mode
