| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple IF and a sum
Hi,
I have a formula with multiple if statements that result in an amount due or an NA. Is it possible to add an under or overpayment into this? G2 would be the result of amount paid - amount due. The Five (5)'s are options chosen from a dropdown list which then looks at T2, a subtotal of products. =IF((H2="FIVE (5)"),T2,IF((H2="SIX (6)"),T2,"NA")) =if((h2="five (5)"), $100, If((h2="six (6), $100, "NA" $100 would be the amount due each month based on starting month. Due in May = $100. Not due until June $100 and May would have NA. If May payment was $75, then I need the June payment to add $100+$75. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
| how to make a macro to clear multiple cells from multiple worksheets? | Excel Worksheet Functions | |||
| Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
| Macro: Filter Multiple header then extract to Multiple Files | Excel Discussion (Misc queries) | |||
| view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
Hybrid Mode
